You can use Microsoft Visual Basic to write procedures which dynamically create, delete or modify data and objects such as forms and reports in Microsoft Access database. If a VBA project in MS Access database gets corrupt, it adversely affects the various components forms, reports or modules. In such situations you won’t be able to access or restore important components of the affected database. You can cope with the problem if you have an updated backup available. However, if no backup is available, you would be required to employ effective Access repair steps. If nothing works out, then you must consider using third-party software.

Consider a scenario, wherein, you attempt to open the Visual Basic Editor in a Microsoft Access 2000 database (by pressing Alt + F11), and you may receive the following error message (s):

“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 doesn’t exist.

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.”

And, if you then try to close the database, Access may stop responding or generate another error message.

Cause

As per the above error message and symptoms, it is clear that its a case of corrupt VBA project.

Resolution

As told earlier, VBA project corruption has a cascading effect on other database components which made use of it. Therefore, in order to restore the vital objects, it becomes essential for you to execute the following Access database repair steps:

1. Create a new blank database
2. Open the affected database, and then click Tables under Objects
3. Right-click the first table, and then click Export on the shortcut menu
4. In the Export to box, browse to the new database (created in step 1)
5. Click the database, followed by OK
6. Repeat steps 4 to 6 for each table, query, macro etc

If the above steps do not yield results, then it is recommended that you opt for advanced and professional Access repair software. Such tools do not modify the original data and recover information from corrupt Access databases efficiently.

Stellar Phoenix Access Recovery is a powerful application which repairs a corrupt .mdb or .accdb file and stores it to a user-defined location. Compatible with MS Access 2007, 2003, 2002 and 2000, the Access database recovery software recovers all components including tables, forms, reports, queries, macros, and modules etc.