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

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

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.

For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base: