Under some circumstances, Access users need to convert a database from one file version to another. It is a very useful option, provided by Microsoft Access. But sometimes, when you attempt to convert Access 97 MDB file to Access 2002, the process may fail and you may get the following error message:
'An error occurred while loading Form_FormName. Do you want to continue?'
Followed by the second error message:
'The Visual Basic for Applications project in the database is corrupt.'
Because of these error messages, the conversion fails and your database becomes completely inaccessible.
Grounds of the issue
You get above error messages if the Access database that you are attempting to convert from one file version to another is not in the compiled state, or the database was damaged before you have tried to convert it.
Whatever the cause of this problem is, the ultimate result would be the incomplete conversion of the data and corruption in MDB file. It is never accepted due to the importance of stored data and thus you need to have required actions to get your database repaired.
Resolution
To fix this problem, you can use any of the below given methods:
? Use Compact and Repair to get the database repaired and then restart conversion.
? In spite of converting the database, import database from Access 97 into 2002.
? Delete references to Utility.mdb and then reattempt conversion.
Though, these methods work in some cases and can fix the problem, but if you are having problem due to corrupted MDB file, you need to use some advanced methods for Access recovery.
Access recovery is best possible using the third party Access recovery software. These software are very powerful and carry out excellent Access repair in almost all possible cases of MDB corruption. Without having any sound and prior technical knowledge, you can use these software very easily for perfect Access recovery.
Stellar Phoenix Access Recovery is the best suitable Access repair software for having trouble-free, quick and absolute Access recovery. Having cool looking and intuitive user interface, this Access repair software is extremely easy to use. You can use this advanced Access recovery software for all file versions of Microsoft Access including Access 97, 2000, 2002, 2003 and 2007.
About the Author:
Simpson Raid is a freelancer for Stellar which offers data recovery software and file recovery programs for different OS and file system.