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 going to get help from this post. As 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….!
Undoubtedly, MS Access is powerful MS Office program which are greater in capabilities than that of 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 programs, 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 screenshot of this particular error message.
When this error message prompts up on your screen, you can click on the OK button. So, that MS Access program tries to repair the corrupt or damaged database by 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:
This error itself indicates that MS Access has failed in its attempt to repair the database file.
What’s This 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.
You Might Also Be Interested In:
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 display error 2317 and further quits the Open operation.
Workarounds To Repair Access Database Inconsistent State Error
Well, you can try these few mentioned solutions to repair MS Access database inconsistent state issue.
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 database. Click on File.
Step 2: Point the cursor to Info and then click on Compact and Repair Database.
Step 3: Now in the Database to Compact From 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.
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 new database and then click OK.
- Make selection for the radio button “Import 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 help of Access inbuilt repair tool i.e ‘Compact and Repair’ utility which performs two functions. Firstly, it compact 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:
- Run MS Access.
- Go to ‘Tools’ and select ‘Database Utilities’. From there click ‘Compact and Repair database’.
- You will see the “Database to compact from” dialog box. Choose the database you want to compact.
- Assign a name for the newly created compacted database in the “Compact Database Info” dialog box.
- 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’.
Fix #5: Professional Access Repair And Recovery Tool:
Access Repair And Recovery tool is 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.
In addition, the tool is also very helpful for 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 help in easy retrieval of Form And Modules that are encrypted using passwords.
Main Features of Access Repair And 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
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 connection 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 user to work on the same network at same time.
Now you know what fixes you can try to fix this “Access Database In An Inconsistent state” error. However Access Repair And Recovery software is the best fix as its benefits overweigh the benefits provided by other solutions. It is no way comparable to other solutions as it has rear chances to get failed to Repair Access Inconsistent State.