Saturday, March 20, 2010

Corrupt Visual Basic for Applications Project Makes Access Database Inaccessible

Are you unable to open the VBE (Visual Basic Editor) in MS Access database? Is your Microsoft Access database, which has VBA (Visual Basic for Applications) code, inaccessible? This behavior may indicate corruption of Access database objects or entire database, and lead to inaccessibility of the database (MDB or ACCDB). You need to restore database from a backup in such cases. However, if the backup is either not complete or not available, access database recovery becomes need of hour.

When you attempt to open VBE in MDB or ACCDB database (by pressing the Alt + F11 key), you may encounter either of the below error messages:

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

When you try to exit the Access database, application might stop responding and you may come across nay of the below error message:

This program has performed an illegal operation and will be shut down.
If the problem persists, contact the program vendor.
MSACCESS caused an invalid page fault in MSACCESS.EXE at 0137:3002d909.
An application error has occurred
and an application log is being generated.
MSACCESS.exe
Exception access violation(ox0000005),Address; 0x3002d681

If you try to Repair Access File by compacting the database, you receive further error message stating:

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

Cause

This problem occurs if Visual Basic for Applications project is either corrupt or damaged. It may get corrupted due to improper system shutdown, application crash, virus infection, and more.

Resolution

You can sort out this problem by restoring Access database from the most recent backup. However, if the backup is not complete or not available, third-party Access File Repair software help you to repair and restore the database.

The access repair applications use high-end database scanning techniques to perform scan of whole database and restore all of its objects. They enable you to repair the database on your own as they have simple and rich graphical user interface.

Access Recovery is the most advanced utility to absolutely repair and restore damaged Microsoft Access database. The software works well with Microsoft Access 2007, 2003, 2002, and 2000. It restores all database objects such as tables, VBA, reports, forms, and constraints.

No comments:

Post a Comment