Docstoc

Corrupt VBA Project Error While Converting and Access Database To 2002

Document Sample
Corrupt VBA Project Error While Converting and Access Database To 2002 Powered By Docstoc
					?
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.

				
DOCUMENT INFO