Access reports that databases are in an 'inconsistent state'

New Contributor

Hi Everyone,


I need some help with this Issue. Background: we moved from an office 2010 .adp project to a access 2016 database project the access database project has custom vba/DAO and linked tables to a backend sql server 2012. We host the access project on a network share which was never an issue in the past, but now we have noticed that the file size of the access project will grow and then users will start receiving the "inconsistent state" message? at the link below there is a report that this is a known issue. I am not able to update the leasing on the server as noted in the work around area of the article. Does anyone have any suggestions or advice on how to fix this issue?


3 Replies



Make sure each user of the application is storing the Access frontend on their local PC and not sharing it with anyone else on the network. One advantage to this approach is when a user goes down no one else does.


One drawback is having to rollout new versions of your frontend to everyone, but if you search the web you will find solutions to this issue.


Hope that helps!


@Juan Soto


thank you Juan, I was able to figure out a work around. We marked the access database file as readOnly and the issue/error went away and the database quit growing. I would rather have users have a shortcut on their desktops then a copy of the file. thanks for your response. 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies