After you convert an Access 2000 replica set from the Access 2000 file format to the Access 2002 file format, some replica set members contain both an MSysAccessObjects table and an MSysAccessStorage table.

Back to the top

You have converted the member replicas, and opened and synchronized them to the Access 2000 file format Design Master instead of to the Access 2002 file format Design Master.

Back to the top

After you convert the Design Master to the Access 2002 file format, synchronize all other replica set members to the Access 2002 file format Design Master. Disregard the extra table if it appears in Access 2002 file format replicas. There are currently no known issues that result from having this extra table in replicas.

Back to the top

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Back to the top

In Access 2002, the MSysAccessStorage table replaces the MSysAccessObjects table when you convert to the Access 2002 file format. Under normal conditions, you will never have both of these tables in a database. Access 2002 automatically handles creating the correct storage during the conversion process and removes the obsolete table. When you convert from the Access 2002 file format to the Access 2000 file format, Access creates the MSysAccessObjects table, moves the object storage into the MSysAccessObjects table, and then deletes the MSysAccessStorage table. The reverse happens when you convert from Access 2000 to Access 2002 file format.

NOTE: This information relies on the use of system tables stored with your database. These tables are undocumented and are subject to change in future versions of Microsoft Access.

Back to the top

Steps to Reproduce the Behavior

1.	In Access 2002, create a new Design Master and replica in the Access 2000 file format, and then quit Access 2002.
2.	Start Access 2002, and then convert the Design Master that you created in step 1 to Access 2002 format. To do so, point to Convert Database on the Tools menu, and then click Access 2002 File Format.
3.	In Access 2002, open the replica that you created in step 1.
4.	In Access 2002, synchronize the replica with the converted Design Master. To do so, point to Replication on the Tools menu, and then click Synchronize Now.
5.	View the system objects in the replica. To do so, click Options on the Tools menu. Click the View tab, and then click to select the System Objects and Hidden Objects check boxes.
6.	In the Database window, click Tables under Objects. Note the MSysAccessObjects and MSysAccessStorage tables.
7.	Open the replica in Access 2002.
8.	Repeat steps 5 and 6 for the replica.

Note that the MSysAccessObjects table still exists in the Access 2002 file format.

Back to the top

For more information about converting replica set file formats, click Microsoft Access 2002 Help on the Help menu, type Convert an Access File in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For more information about converting replica set file formats, click Microsoft Access 2002 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 topic.

Back to the top