Error Message: “Visual Basic for Applications Project in This Database Is Corrupt”

While you try opening the Visual Basic Editor in MS Access database (by pressing Alt+F11), you might encounter one or more of the error messages mentioned below:

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

Or

The module name ‘module name’ is misspelled or refers to a module that is invalid.

If the invalid module name is in a macro, an Action Failed dialog box will display the macro name and the macro’s arguments after you click OK. Open the Macro window, and type the correct module name.

If you come across such messages, try to close the database as it might stop responding or start displaying some of the following error messages:

On Microsoft Windows 95 or Microsoft Windows 98:

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

If the problem persists, contact the program vendor.

When you click Details on MS Windows Millennium Edition, press Alt+D and you receive the following message:

MSACCESS caused an invalid page fault in MSACCESS.EXE at 0137:3002d909.

NOTE: The actual memory address may vary

On Microsoft Windows NT:

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

MSACCESS.exe

Exception access violation (ox0000005),Address; 0×3002d681

Furthermore, you also see the error message given below when you try to compact the database:

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

Root Cause of the Issue

As the error messages suggests there is probably some corruption issue. It is quite possible that the Visual Basic for Applications project has gone corrupt.

Resolving the Issue

In Access Repair files, data such as forms, reports, and modules utilize Visual Basic for Applications. This implies that corruption of Visual Basic for Applications project might affect forms, reports, and modules in form of corrupting them in-return. For retrieving your tables, queries and macros, follow the steps given below:

1. Create a new blank database.

2. Open the problem database and click Objects > Tables.

3. Right click first table, click Shortcut menu > Export.

4. In Export to dialog box, browse to the database that was initially created.

5. Click the database icon and click OK.

6. Repeat step 4 and 6 for each table, query, and macro.

Usually, the steps given above restore the database. However, in case you fail to restore Access Database

use the qualitative third party MDB repair software to retrieve your lost data. MDB database recovery software is the safest and best way to recover damaged, inaccessible, and corrupt data. The software supports Access 2003, Access 2000, Access 97, and Access 95.

Comments are closed.