5 Fixes To Repair Access Database That Is In An Inconsistent State

Is your Access database is frequently showing “MS Access Has Detected That This Database Is In An Inconsistent State” error?

If yes, then you will surely be going to get help from this post. This post covers complete information about this particular Access Database inconsistent state along with the best fixes to resolve this.

 So let’s get started….!

What’s This Access Database Inconsistent State (9505)?

Undoubtedly, MS Access is a powerful MS Office program that is greater in capabilities than that Excel mainly when it comes to the creation of databases for storing or managing data.

Being an Access application user, you must have experienced that it is very easy to submit queries about information stored in the database, produce reports from it or modify the data in it. However, all these don’t make this Database Management System (DBMS) immune to becoming corrupt. And the reason of this can be several such as mishandling, loopholes in the program itself, etc. Like any other program, you sometimes may encounter different messages in your Access database too. Here we are discussing one very common Access error i.e Error 9505 continued with message:

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

Here is a screenshot of this particular error message.

 database is in an inconsistent state

When this error message prompts up on your screen, you can click on the OK button. So, the MS Access program tries to repair the corrupt or damaged database on its own. If MS Access fails to repair the database, it will display Error 2317 whose message will appear like this:

“The database ‘xxx.mdb’ can’t be repaired or it is not a Microsoft Access database file.”

In this, ‘xxx.mdb’ is name of the corrupt Access database file. Have a look at the screenshot of this error:

Error 2317

Note:

This error itself indicates that MS Access has failed in its attempt to repair the database file. 

Whats The Reason Of Error 9505 “Access Database inconsistent state?

As we all know that MS Access is a combination of Relational Microsoft Jet Database Engine, software development tools, and a graphical user interface.  So, when the Access Jet Database Engine recognizes the basic structures and important definitions of the MDB database file but finds some inconsistency in the table definitions or table data, then it comes up with the error code 9505 i.e Database Is In An Inconsistent State error.

After this, Access itself tries to sort out these inconsistencies and repair the database. But if it fails to fix this inconsistency in table definitions that are significant to the complete database. Thus when it fails to repair this then it displays error 2317 and further quits the Open operation.

How To Fix Access Database Inconsistent State Error?

The following are the methods that you can try to fix Microsoft Access has detected that this database is in an inconsistent state issue.

 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

Let’s talk in detail about each of these methods.

Fix #1: Try Integrated Compact Utility

You can make use of Access built-in JET Compact Utility as this tool is mainly designed to resolve

Minor corruption issues occurred in Access. Although this utility helps in sorting out the minimal intensity damage, it doesn’t fix higher level Access errors. So you can make a try with it.

Step 1: Open Access, but do not open the database. Click on File.

how_to_compact_and_repair_a_database_manually_in_access_2016

Step 2: Point the cursor to Info and then click on Compact and Repair Database.

how_to_compact_and_repair_a_database_manually_in_access_2016

Step 3: Now in the Database to Compact From the dialog box, browse and select the database that you want to compact and repair.

Note: Make sure that nobody is using the database file, or else the compact and repair utility will fail.

Have a look at the video to repair Access database using compact and repair utilities:

Fix #2: Import Corrupt Database

Create a new database and while keeping it empty, try to import a table into it. If successful, then users can import all the Tables into the new database. This is suggested because there are some Access database errors that cannot be fixed by Compact and Repair utility. To import the database into the new database, follow these steps:

Try importation of corrupt access database into a new access 2010 database file by following these steps:

  • Open MS Access and create a new database file.
  • Tap on Access to import Access database under the External Data tab.

Import Access Database 1

In the next pop-up window, click on Browse and locate the database file while it is imported.

  • Specify the place and techniques to store data in a new database and then click OK.
  • Make a selection for the radio buttonImport tables, forms, reports, macros and, modules into the current database. and press OK button.

  • In the next window select for all database objects that you want to import and Click to the Ok.

Fix #3: Compact The Database

You can take the help of the Access inbuilt repair tool i.e ‘Compact and Repair’ utility which performs two functions. Firstly, it compacts the database by releasing the deleted space which is excessively captured by the database and only serves to corrupt the database and fragment the stored data. Secondly, it tries to repair the database.

Try reducing the size of the database using the compact and repair utility as follows:

  1. Run MS Access.
  2. Go to ‘Tools’ and select ‘Database Utilities’. From there click ‘Compact and Repair Database’.
  3. You will see the “Database to compact from” dialog box. Choose the database you want to compact.
  4. Assign a name for the newly created compacted database in the “Compact Database Info” dialog box.
  5. Click on “save”

Fix #4: Run The Compact And Repair’ Utility In Command Line Switch

Execute the ‘Compact and Repair’ utility in command line switch. You can use this if because of this “database is in an inconsistent state” error your access database is not opening.

 To do this, create a shortcut and then for the target, use

C: \Program Files \Office11\msaccess.exe” “C:\pathtodatabase\database.mdb \repair

Note: Here replace the ‘two paths placed in quotes’ with the ‘actual path to your access executable and database’.

The following Command can be easily used for compacting the Access database at the command line or using a  Batch File.

C:\Program Files\Microsoft Office\Office\MSAccess.exe” “C:\MyDatabase.mdb” /compact “C:\Backup.mdb”

Fix #5: Professional Access Repair And Recovery Tool

access repair and recovery

Access Repair And Recovery tool is a popular access database recovery software to recover corrupt MS Access files and repair the damaged database files. This tool has the ability to fix almost all minor and major corruptions, the tool restores damaged database objects like tables, linked tables, indexes, modules and macros, etc.

* By clicking the Download button above and installing Stellar Repair for Access (14.8 MB), I acknowledge that I have read and agree to the End User License Agreement and Privacy Policy of this site.

In addition, the tool is also very helpful for the recovery of all the records, which were deleted earlier from the database. The tool includes options to search for access databases in the system and has options like find that allows you to search for various database objects, such as queries, tables, etc in the scan result. As an additional advantage, this professional tool also helps in easy retrieval of Form And Modules that are encrypted using passwords.

Main Features Of  Access Repair And Recovery Tool

Features of MS Access Database Repair & Recovery Tool

  • Easily repair corrupt MS Access MDB or ACCDB database files
  • Restores damaged Tables, Queries, Indexes, Linked Tables, Calculated Data Type, Relations, etc.
  • Finds fixed database items in the Scan Tree
  • Supports MS Access 2016/ 2013/ 2010/ 2007/ 2003/ 2002/ 2000
  • Enables selecting corrupt database files from your PC
  • Retrieves password-protected forms and modules
  • Recovers all deleted records to a new database

Steps To Use MS Access Repair and Recovery Tool

Tips To Avoid MS Access Inconsistent State Error In Future Again

In order to avoid MS Access Database corruption follows the below-mentioned tips:

#Tips 1 – Create Backup Frequently

You should maintain the backup of your MS Access Database. If you maintain the backup your MS Access database regularly then you can always have the option to restore data from the backup when your Access Database gets corrupted.

#Tips 2 – Close MS Access Application Properly

It is always suggested that you must make sure to properly exit your MS Access Application properly. Select File>Exit option to close the application properly.

#Tips 3 – Close All the Connections

As and when you finish your work, it is suggested that you must close all the connections in the database.

#Tips 4 – Split your Database

If your MS Access database is accessed by two or multiple users then it suggested that you must split your database into two parts – a front end that stores queries, forms, reports, and data access pages and in the back end stores the entire table along with data stored in it.

#Tips 5 – Do not allow Mac and Windows users to work on the same network

If you allow Windows and Mac users to share the same network then chances for MS Access corruption become higher. It is because Mac creates heavy traffic while transferring and printing graphic files. Hence, it is recommended that you must not allow Windows and Mac users to work on the same network at the same time.

Conclusion:

Now you know what fixes you can try to fix this “Access Database In An Inconsistent state” error. If manual fixes fail to resolve the Access Database Inconsistent state issue then you can approach for automatic solution i.e Access Repair And Recovery software.  It is no way comparable to other solutions as it has rear chances to get failed to Repair Access Inconsistent State.

tip Still having issues? Fix them with this Access repair tool:

This software repairs & restores all ACCDB/MDB objects including tables, reports, queries, records, forms, and indexes along with modules, macros, and other stuffs effectively.

  1. Download Stellar Repair for Access rated Great on Cnet (download starts on this page).
  2. Click Browse and Search option to locate corrupt Access database.
  3. Click Repair button to repair & preview the database objects.

Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access & sharing tech blogs.