You are currently offline, waiting for your internet to reconnect

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

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: 07/03/2003 23:59:00 - Revision: 2.0

  • Microsoft Access 2002 Standard Edition
  • Microsoft Access 2000 Standard Edition
  • kberrmsg kbprb KB818099
Feedback