Q248960 ACC2000: "Visual Basic for Applications Project in This Database Is Corrupt".

Symptoms

When trying to open the Visual Basic Editor in a database you may receive any of the following errors:

”The Visual Basic for Applications project in this database is corrupt”

“The module name 'module name' is misspelled or refers to a module that doesn't exist.”

When the invalid module is in a macro an ‘Action Failed’ message display the macro name and the macro's arguments after you have clicked on ‘ok’. Open up the Macro window then type in the correct name of the module. If you try to close the database now the program may crash or you could get any of the following errors:

“This program has performed an illegal operation and will be shut down.”

“If the problem persists, contact the program vendor. “

When you try to click on ‘Details’ you may receive this message:

”MSACCESS caused an invalid page fault in MSACCESS.EXE at …..”

Or if you are running Microsoft Windows NT you may receive this message:

”An application error has occurred and an application log is being generated.”

MSACCESS.exe

Exception access violation(ox0000005), Address; 0x3002d681

You could also get the error:

“The Visual Basic for Applications project in this database is corrupt” when attempting to compact the database

Cause

The Visual Basic for Applications project has become corrupt.

Resolution

If the Visual Basic for Applications project has become corrupt, then the objects will be affected and cannot be restored.

In order to save the macros, tables and queries, carry out the following:

1. Create new database.
2. Open up the damaged database and click on ‘Tables’.
3. Right click on the initial table then click ‘Export’.
4. In Export dialogue box navigate to the new database.
5. Select it and then click OK.
6. Repeat step numbers 4 to 6 for each macro, table and query.

*If you try to export any forms, reports or modules you will get the same error messages as before.