Access reports that databases are in an 'inconsistent state'

Last Updated: June 14, 2018

ISSUE

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.

STATUS: WORKAROUND

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:

  1. Click Windows Start  Press the Windows key and then type Command. Right-click on Command Prompt and choose Run as administrator

  2. 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

  3. Close the command prompt window.

More Resources

Icon Experts (brain, gears)

Ask the experts

Connect with experts, discuss the latest Excel news, updates, and best practices, and read our blog.

Microsoft Tech Community

Icon Community

Get help in the community

Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.

Office Forum on Answers

Icon feature request (light bulb, idea)

Suggest a new feature

We love reading your suggestions and feedback! Share your thoughts. We're listening.

UserVoice for Office

See Also

Fixes or workarounds for recent issues in Access

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×