Access database corruption after conversion from 2003 to 2007 version

With Microsoft Access 2007, you can open and use databases created in earlier version viz Microsoft Access 2000, 2002 and 2003. Moreover, you can also convert databases created with earlier previous versions of Access into the new Office Access 2007 file format. The conversion or migration enable you to bank upon the new functionalities and features available in Access 2007. At times, you might face problems with the converted database. The major problems are corruption and data inaccessibility. To tackle such issues, you must have a clean and updated backup copy of the database. However, if no backup is available, you do not have a better option than grabbing a third-party Access recovery software.

Consider a scenario, wherein, you convert a database created with Microsoft Access 2003 to 2007 format. It works fine for a good number of days until you receive the following error message:

"Microsoft Office Access has detected that this database is in an inconsistent state, and will attempt to recover the database. During this process, a backup copy of the database will be made and all recovered objects will be placed in a new database. Access will then open a new database. The names of objects that were not successfully recovered will be logged in the 'Recovery Errors' Table."

In a multi-user environment, the affected database would become inaccessible to all the users following this error message.

Cause

The Access database is acting erratically as it has become corrupt. It could become corrupted owing to many reasons including abrupt system crashes, power fluctuations, application malfunctioning etc. Another reason could be simultaneous efforts to write or modify data at the same location by different users.

Resolution

The following steps will guide you in performing Access database recovery:

• Close the MS Access database file. If you are compacting a shared Access database which is located on a server or shared folder, make sure it is not opened by any other user.
• In the Tools menu, locate Database Utilities, and click Compact and Repair Database option
• Mention the name of the Access file you want to compact in the Database to Compact from dialog box and click Compact
• Click Save
• The original Access file gets replaced with the compacted version at the same location

If you do not get the satisfactory results from using the inbuilt Compact and Repair utility, then download an advanced Access recovery software from the Internet.

For instant and best results, you can blindly trust Stellar Phoenix Access Recovery. The application is designed to help you repair corrupt MDB or ACCDB files. This risk-free application supports MS Access 2007, 2003, 2002 and 2000 and recovers all database components including tables, forms, reports etc.