You also see the following error message when you try to compact the database:
The Visual Basic for Applications project in this database is corrupt.
The Visual Basic for Applications project is corrupted.
Forms, reports, and modules use Visual Basic for Applications. If the Visual Basic for Applications project is corrupted, forms, reports, and modules are affected by this corruption and cannot be restored.
To save your tables, queries, and macros, follow these steps:
Create a new blank database.
Open the problem database, and then click Tables under Objects.
Right-click the first table, and then click Export on the shortcut menu.
In the Export to dialog box, browse to the database that you created in step 1.
Click that database, and then click OK.
Repeat steps 4 through 6 for each table, query, and macro.
NOTE: When you try to export forms, reports, or modules, you will receive the error messages detailed at the beginning of this article.
Microsoft has confirmed that this is a problem in Access.