Compact Database Conversion Method can lead to Access Database Corruptionc

in Database

Have you converted an Access database using the Compact Database method? Are you experiencing problems with the converted database? Issues are bound to plague an Access database converted to a later version using the Compact Database 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 repair 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 Compact Database method. Instead of using the Compact Database 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.

Author Box
Bury Shane has 1 articles online

Bury Shane is an active blogger, article writer and technical expert who explores all the latest and hot topics. SQL Recovery is one of the burning issues that people faces day by day and therefore this article has been written describing about the Stellar Phoenix MYSQL Database Recovery Software.

Add New Comment

Compact Database Conversion Method can lead to Access Database Corruptionc

Log in or Create Account to post a comment.
     
*
*
Security Code: Captcha Image Change Image
This article was published on 2010/10/20