1. Home
  2. Database
  3. Microsoft Access
  4. Microsoft Access Error Messages
  5. “Microsoft Access has detected that this database is in an inconsistent state, and will attempt to recover the database. During the process…” – Microsoft Access Error

“Microsoft Access has detected that this database is in an inconsistent state, and will attempt to recover the database. During the process…” – Microsoft Access Error

Summary

This Error Message Article explains the Microsoft Access error message “Microsoft Access has detected that this database is in an inconsistent state, and will attempt to recover the database. During the 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 the new database. The names of the objects that were not successfully recovered will be logged in the “Recovery Errors” table.” and details how to fix the underlying problem that caused it to appear.

Explanation

Most likely the database has been corrupted. Access will attempt to trigger a rebuild as long as the file is not locked by another user or service.

Solution

If the rebuild fails, select ‘Compact and Repair Database’ in the Database Tools tab.

Additional Comments

Related Articles:

  • Access Database is Corrupted – KBA-01420-P0C8X9
  • Rebuild a Database with the “Compact and Repair Database” Feature – KBA-01417-P0N4N6

Issue Found: Access 2010 running on Windows 2008 R2 Server

Updated on August 3, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support