Article ID: 818099
Article Last Modified on 7/3/2003
APPLIES TO
- Microsoft Access 2002 Standard Edition
- Microsoft Access 2000 Standard Edition
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:
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.
- Run Access.
- Open Database_1 database.
- On the Tools menu, click Options.
- On the View tab, select the System objects check box and then click OK.
- In the Database window, click Tables in the left pane.
- In the right pane, select and then delete TempMSysAccessObjects table.
=== Method 2
Import the Database to a New Database ===
- Run Access.
- Create a new database. Name the new database Database_2.
- Make sure that the view for System objects is not selected. To do this, follow these steps:
- In the Database window on the Tools menu, click Options.
- On the View tab in the Options dialog box, clear System objects and then click OK.
- On the File menu, point to Get External Data and then click Import.
- In the Import dialog box, select Database_1 database and then click Import.
- In the Import Objects dialog box, click Options.
- In the Import Objects dialog box, click Select All.
- Under the Import section, select both the Menus and Toolbars check box and the Import/Export Specs check box.
- In the Import Objects dialog box, select each tab and then repeat step 7 for each of the tabs.
- In the Import Objects dialog box, click OK.
- 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. - Quit Access.
- Rename Database_1 database to Database_1_Backup.
- 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
Keywords: kberrmsg kbprb KB818099