Access Database is getting corrupt again and again

Anonymous
2018-06-01T17:47:41+00:00

We have an application which was working okay till last month. But after the last windows update our clients are getting issues with access database. access database got corrupted.  We ran compact and repair. But it still getting corrupted again and again.  This issue started right after the window update. clients are on different OS. Like server 2018, server 2012 and windows 10.

Is there anything i have check in new windows update or any other step to prevent database corruption?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

604 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2021-01-15T10:11:53+00:00

    Hi Mark,

    We are not driving people away from Access on purpose, and do understand the pain this problem has caused.

    We won't give up, and will update status here when we can: https://support.microsoft.com/en-us/office/access-reports-that-databases-are-in-an-inconsistent-state-%EF%BB%BF-7ec975da-f7a9-4414-a306-d3a7c422dc1d

    Shane Groff

    Access Engineering

    Hi Shane,

    It has been 6 months since the last update. Please will you post another update when you get a chance?

    Thankfully the official work around still seems to be working for the clients who have been affected, but their IT departments would like to restore normal server functionality asap. In the meantime, the official page needs to show that it is still being worked on please!

    Many thanks,

    David Nye

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2020-11-11T16:30:12+00:00

    This famous bug strikes again at work after 3 normal months, "database is in inconsistent state". We do not have leasing disabled option or revert back the update as there are 10-15 users on the same server. Any help greatly appreciated, Thanks

    Was this answer helpful?

    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  4. Anonymous
    2020-09-17T07:54:00+00:00

    @ Kiwi_Mark

    Good luck! So far using the DisableLeasing hack on the client PC's "seems" to be working (no corruption as yet). But the DB in question gets very seasonal use, and only really starts getting worked in Oct, so we shall see....

    Was this answer helpful?

    0 comments
  5. Anonymous
    2020-09-09T00:38:47+00:00

    @Duncan B - we appear to have a similar issue. Although it does seem more stable with the backend file share on Linux than it was on the Windows 10 machine we were using last year. Have not tried the FileCache solution yet.

    Was this answer helpful?

    0 comments