In Access 2002, you can link a replicated Access 97 database and view the data. If you try to add or edit a record, however, you receive the following error message:

Back to the top

To add or edit records, you must convert the replica set to the current version.

For more information about how to convert an earlier-version replica set to the Access 2000 or the Access 2002 file format, click Microsoft Access Help on the Help menu, type about converting an Access file in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Back to the top

Steps to Reproduce the Behavior

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

1.	Use Access 97 to open the sample database Northwind.mdb.
2.	On the Tools menu, point to Replication, and then click Create Replica.
3.	After the replica is created, quit Access 97.
4.	Open Access 2002.
5.	In the Task Pane, click Blank Database under New.
6.	In the File New Database dialog box, type TestLink in the File name box, and then click Create.
7.	On the File menu, point to Get External Data, and then click Link Tables.
8.	In the Link dialog box, locate the replicated database that you created in step 2, and then click Link.
9.	Click the Employees table, and then click OK.
10.	Open the Employees table, and then try to edit data. Note that you receive the error message that is mentioned in the "Symptoms" section.

Back to the top

There is an add-in for Microsoft Access 97 that you can use to convert the Design Master database from a replica set to its original, nonreplicated state. For additional information about this add-in, click the article number below to view the article in the Microsoft Knowledge Base:

Back to the top