Monday, August 4, 2008

VBA project is damaged in MS Access

Microsoft Access is an application used to create computer databases that can be used on a Windows operating system or on a web site. For making our work easy Microsoft Access is also equipped with a library, the Microsoft Access Object Library so that you can use them to create and manage databases by specific program. To code database file we use VBA application and save file as a VBA project. If we want to modify or change the file we have to modify VBA source code.

As VBA file depend upon source code, any deletion in source code can corrupt VBA file. Most common error for VBA file is “VBA project is damaged”. This problem come up only if you try to convert an Access 97 database to Access 2002. Main cause of corruption is that Access 97 is not in a fully compiled state. If errors indicate corruption due to a Visual Basic Application (VBA) or macro, you may recover the affected tables, queries and macros by exporting them from the corrupted database and into a new database

For resolution of this problem you can use compact and repair utility. But it has some limitation, so you will not be able to export forms, reports and modules. These objects must be recovered from backup. Second method is open your database in Access 97, and issue a Compile and Save All Modules from the Debug menu in VBE before attempting to run the conversion process again. If still your database is not recovered or repaired then you must use any access repair software.

Stellar Phoenix Access Recovery software can recover or repair your VBA project file with 100 % accuracy. It performs a thorough scan of the damaged VBA projects, MDB files; rectifies, restores and repair access files with their Tables, Queries, Forms, Module and Reports intact. This software is compatible with all version Microsoft Access.