Converting the database developed in Access 97 to Access 2002, may yield the

following error message:

"An error occurred while loading Form_FormName. Do you want to continue."

Thereafter another error message follows which states that:

"The Visual Basic for Applications project in the database is corrupt."

VBA or Visual Basic for Applications is an implementation by Microsoft to be run on applications like MS Access and allows the users to develop custom solutions by the use of language Visual Basic.

The occurrence of these error messages may be a result of the corruption in the database prior to when you are trying to convert in Access 2002 or it may also happen that the database to be converted is not in the compiled state in the Access 97.

The corruption of the Access database may not be good enough to few of the users as the data stored in them may be of peak relevance to the user, its business and its customers. The databases are used to store several of the important information like of current or past dealings, credits and debits of the organization and stock status. So any of the loss in this data is never appreciated by the user and the search of tool which can perform Access Repair begins.

Although few of the solutions have also been suggested by Microsoft itself to sort out the issue, which are listed below:

 Compact the database.

 Importing the objects of the Access 97 database directly to the Access 2002 database.



 Opening the database of earlier version and then remove the references to utility.mda

These solutions work only in those cases when the corruption in the database is due to some internal reasons or the database is not compiled while for the corruption in the database due to external reasons, there is no option other then to have Access Repair software.

The Access Repair software are able to repair the databases due to any of the reason. These software scan the corrupted databases and extract the data from them. The user feels no kind of difficulty in running the software as they come with the easy to operate user interfaces.

Stellar Phoenix Access Recovery software is one of those Access Repair software and provides the most excellent options comparatively. This Access Repair software works well with all the file versions of Access counting Access 97, 2000, 2002/ XP, 2003 and 2007.

If you have applied any of the relations between the tables or have inserted any of the query, form, report, macro or module in the database, then the software can perform access repair for all of them. The user need not to technically so able in order to use the software and the preview of the repairable files can be obtained via the demo version of this access repair software available on the company´s website.