Have you converted an Access database using the CompactDatabase method? Are you experiencing problems with the converted database? Issues are bound to plague an Access database converted to a later version using the CompactDatabase method. Since this method leaves the database in a partially converted state, the possibilities of it becoming corrupt reach their peak point. Due to corruption, you might have to encounter various error messages along with data inaccessibility. In such situations, you must use the backup copy of the original Access database and convert it using the Convert Database command. However, if no such backup is available, you should grab a professional access recovery software to resolve corruption errors and recover the vital data.

Consider a scenario, wherein, you have an Access database which you are trying to open in MS Access 2007. The database doesn't open and you receive the following error message:

"The database is in an unexpected state."

The above error message sounds warning bells and gives an indirect hint that you need to perform Access recovery in order to eliminate the error message and bring back the database in a healthy state.

Cause

The error message is often observed if you use the Data Access Object (DAO) library and convert an Access database created in an earlier version by using the CompactDatabase method. Instead of using the CompactDatabase method, you should have considered using the Convert Database command.

Resolution

You must observe the following steps in order to resolve the problem with the Access database:

Use the Convert Database command (If you have the original database) 1.Make a backup of the original Access database file 2.Open the database 3.When you open the database, Access shows the Database Enhancement box, you will also get a prompt to upgrade the database 4.Click Yes to upgrade the database to whichever file format which you have chosen to be the default file format in Access 2007. In case, you do not have the original database, you must download and use a third-party software. Such tools repair corrupt Access databases efficiently.

Databases created with MS Access 2010, 2007, 2003, 2002 and 2000 versions can be easily repaired and recovered using Stellar Phoenix Access Database Recovery. The application recovers all objects of a corrupt Access database such as macros, tables, modules, forms etc. Developed for Windows 7, Vista, XP, and 2000, this Access recovery utility facilitates recovery of VBA code for MS Access reports.