Friday, September 3, 2010

How to Fix VBA code Corruption in Access

Microsoft Access is a development environment used to create computer-based databases. To make it more user friendly, it transports with a programming language called Visual Basic for Application (VBA) and various libraries. This language and the libraries are used in Microsoft Access objects, like reports, modules, and forms wherein the VBA code is used to create user defined functions. If the VBA gets damaged, these objects can not be accessed you which may cause data loss situations. In such situations such objects can not be restored. So to resolve these issues a user need to opt for access recovery software using appropriate tools.

While accessing Visual Basic editor in Microsoft Access by pressing the ALT + F11 keys access database sheet manifests an error:

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.

Moreover, a user may encounter any of the below error messages while closing Microsoft Access application:

•The Visual Basic for Applications project in the Database is Corrupt
•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

Root of the problem:
As stated in the above error messages, the problem occurs due to corrupt or damaged Visual Basic for Applications (VBA) project.There might be various for a file corruption such as application malfunction,virus infection, virus or Trojan attacks and more.

Solution:
Follow the given steps to recover access database:
1.Create a new database.
2.Open corrupt database and click Tables option under Objects.
3.Right-click first table and select Export.
4.Browse the newly created database in Export to dialog box and click OK button.
5.Repeat step four for every table, macro, and query.

Nevertheless, a user get flunk to repair MDB using the above steps then he needs to use a upgraded and powerful third party tool , known as Access Recovery software.Furthermore this tool also supports MS Access 2010. If a user encounters some error in the same then this tool can be used to repair access 2010 as well and ensures comprehensive recovery using high-end scanning.

No comments: