ACC2002: MSysAccessObjects Table Exists in Access 2002 File Format (282368)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q282368
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

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.

CAUSE

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.

RESOLUTION

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.

STATUS

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

MORE INFORMATION

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.

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.

REFERENCES

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.
Modification Type:MajorLast Reviewed:9/25/2003
Keywords:kbbug kbnofix KB282368
©2003 Microsoft Corporation. All rights reserved.