How to repair Access database that is in an inconsistent state?

  • Replies:2
  • OpenNot stickiedUnanswered
  • Forum posts: 3

Aug 10, 2020, 8:54:04 AM via Website

“Microsoft Access has detected that this database is in an inconsistent state.”

The screenshot of the error message is displayed-image

  • Forum posts: 4

Aug 10, 2020, 1:43:33 PM via Website

When this error message prompts up, you can click on the OK button so that the MS Access program tries to repair the corrupt or damaged database on its own.
If MS Office Access fails to repair the database, it will display Error 2317 whose message is as follows:
“The database ‘xxx.mdb’ can’t be repaired or it is not a Microsoft Access database file.”
Here, ‘xxx.mdb’ is the name of a corrupt Access database file.

Solutions to Repair Access Database in an Inconsistent State Error
1. Run ‘Compact and Repair’ utility in Microsoft Access which performs two functions. Firstly, it compacts the database by releasing the deleted space which is still held by the database and only serves to corrupt the database and fragment the stored data. Secondly, it tries to repair the database.

  1. Run ‘Compact and Repair’ utility by using a command-line switch. You can use this if your Access database is not opening.
    To do so, create a shortcut and then for the target, use: “C: \Program Files \Office11\msaccess.exe” “C:\pathtodatabase\database.mdb” /repair

For more information read this blog-

  • Forum posts: 2

Sep 24, 2020, 1:59:39 PM via Website

Usually this inconsistent error comes when the Access Jet Database Engine recognizes the basic structures and main definitions of the MDB or ACCDB database file. But faces some inconsistency in table data or in table definitions.

You can try different methods to fix this access database Inconsistent State error.

1: Try Integrated Compact Utility
2: Import Corrupt Database
3: Compact The Database
4: Run The ‘Compact And Repair’ Utility In Command Line Switch
5: Professional Access Repair And Recovery Tool

To know how to perform these fixes check out this article:

Recommended by NextPit