Read time: 3 minutes
When MS Access is in an Inconsistent State, it blocks the further working of Access Database. The complete error message is displayed as,
“Microsoft Access has detected that this database is in an inconsistent state, and will attempt to recover the database. During this 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 objects that were not successfully recovered will be logged in the “Recovery Errors” table.”
Once this error appears, you will not be able to access the database till this issue is resolved. The most common reason for database in an inconsistent state is when the Access database file is shared to everyone. The file is prone to corruption e\when multiple users open it. Database files in MDB format are unsplit and includes all forms, modules, reports; in single file. this sometimes causes inconsistent error.
In this article we shall discuss some troubleshooting methods to solve Access Database Inconsistent Error.
Microsoft Access has an inbuilt utility repair software, Compact and Repair Utility. This feature compacts the database by removing the deleted space which is stored in the database and it also repairs the database.
Before starting this method, ensure that nobody is using the database as the compare and utility will not work. You can use the utility to repair the database when the application is unable to access database and its data.
“C: \pathtoAccess\msaccess.exe” “C:\pathtodatabase\database.mdb” /repair.
In the above command replace ‘pathtoAccess’ and pathtodatabase with the actual path of the Access folder.
This method is applicable for Access 2019, 2016, 2013, and Access for MS Office 365.
REG ADD HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters /v DisableLeasing /t REG_DWORD /d 1 /f NET STOP SERVER NET START SERVER
If all the above-mentioned techniques do not work then the last and the most trusted option is to use professional tool to repair inconsistent state in database file. Kernel for Access Database Repair is an expert tool that repairs and restores corrupt and damaged Access Database without any data loss. It recovers all the deleted files and records along with data structures, auto-numbers, primary keys, OLE data, tables etc.
This article briefly describes the workaround to fix Access Database in an Inconsistent State. The most immediate solution is to use Compact and Repair Utility and if that does not work that looking for an expert tool is the best solution. Kernel for Access Database Repair works wonders when it comes to repairing the files without any data loss.