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

WORKAROUND

Method 1
Remove System Table TempMSysAccessObjects

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.