Last Updated: June 14, 2018
When opening a database, you may see the following error message:
"Microsoft Access has detected that this database is in an inconsistent state, and will attempt to recover the database."
If using DAO to open a database from Visual Basic code, you may see error 3343 reported.
This may happen when you have a database stored on a network file share, and multiple users are using the database simultaneously.
The engineering team is aware of and working to fix this issue. In the meantime, disable the leasing on the file server where the database is stored and the client machine where Microsoft Access is running as a workaround. To do this:
Click Windows Start and then type Command. Right-click on Command Prompt and choose Run as administrator.
Copy and paste the following commands into the command prompt window:
REG ADD HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters /v DisableLeasing /t REG_DWORD /d 1 /f
NET STOP SERVER
NET START SERVER
Close the command prompt window.
Ask the experts
Connect with experts, discuss the latest Excel news, updates, and best practices, and read our blog.
Get help in the community
Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.
Suggest a new feature
We love reading your suggestions and feedback! Share your thoughts. We're listening.