PRB: "Table 'TempMSysAccessObjects' Already Exists" Error Message May Occur While Using the Compact and Repair Database Utility

Article translations Article translations
Article ID: 818099 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

When you try to compact and repair a database by using the Compact and Repair Database utility, you may receive the following error message:
Table 'TempMSysAccessObjects' already exists

WORKAROUND

To work around this problem, you can use one of the following methods:

Method 1
Remove System Table TempMSysAccessObjects


Note Use this method when the problem is with Database_1 database.
  1. Run Access.
  2. Open Database_1 database.
  3. On the Tools menu, click Options.
  4. On the View tab, select the System objects check box and then click OK.
  5. In the Database window, click Tables in the left pane.
  6. In the right pane, select and then delete TempMSysAccessObjects table.

Method 2
Import the Database to a New Database

  1. Run Access.
  2. Create a new database. Name the new database Database_2.
  3. Make sure that the view for System objects is not selected. To do this, follow these steps:
    1. In the Database window on the Tools menu, click Options.
    2. On the View tab in the Options dialog box, clear System objects and then click OK.
  4. On the File menu, point to Get External Data and then click Import.
  5. In the Import dialog box, select Database_1 database and then click Import.
  6. In the Import Objects dialog box, click Options.
  7. In the Import Objects dialog box, click Select All.
  8. Under the Import section, select both the Menus and Toolbars check box and the Import/Export Specs check box.
  9. In the Import Objects dialog box, select each tab and then repeat step 7 for each of the tabs.
  10. In the Import Objects dialog box, click OK.
  11. In the Database window on the Tools menu, click Database Utilities and then click Compact and Repair Database.

    Note Make sure that all objects from Database_1 database are imported to Database_2 database.
  12. Quit Access.
  13. Rename Database_1 database to Database_1_Backup.
  14. Rename Database_2 to Database_1.

REFERENCES

For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
209137 ACC2000: How to Troubleshoot and Repair a Damaged Jet 4.0 Database
283849 ACC2002: How to Troubleshoot and Repair a Damaged Access 2002 Database

Properties

Article ID: 818099 - Last Review: July 3, 2003 - Revision: 2.0
APPLIES TO
  • Microsoft Access 2002 Standard Edition
  • Microsoft Access 2000 Standard Edition
Keywords: 
kberrmsg kbprb KB818099

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com