Wednesday, December 14, 2011

Why “This database is in an unexpected state” Error Message Pop Up & Solution of the Error

“This database is in an unexpected state; Microsoft Access can't open it...”

If you find this error message on your PC screen when you try to open MS Access database then it is impossible to open access database. But if you will follow some steps one by one the impossible word can be “Possible”. So here are the steps which you should follow to solve this error message:

First we should know “WHY THIS ERROR OCCURS”?

Possible Causes:
  • This error message pops up when you are trying to convert Access database from a prior version of Microsoft Access by using the DOA compact database method. This has left the access database in an unconverted state.
  • Access Database has been severely corrupted.  

Choosing the Best Solution:


Choose the best solution as per your requirement:
  • If you have a copy of the access database in its original format, Use Convert Database command on the Tools menu (Database Utilities submenu) to convert from a prior version of Microsoft Access instead of DAO Compact Database method.
  • If the original database is not available, create a new database and import your tables and queries to preserve your data. But remember that your other database objects can't be recovered.
  • If you want to recover all objects- In this case you should use Jet Compact Repair utility to repair your access database.
  • If above utility is not able to repair your database because this utility has its own limitation then you can use Access Repair third party tool. Stellar Phoenix Access Recovery Software recovers access database after all access database corruption error.

You can choose any one step or if you don't know about what step you should choose to solve the problem, you can use all four steps one by one. By following these steps you will definitely solve this issue & able to access your database successfully.

No comments:

Post a Comment