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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-07-19T19:41:48+00:00

    We've  applied the Official Microsoft Workaround, made the registry changes to our 2016 Server & workstations. It's been over a week and so far

    we had no problems with our data file accdb getting corrupt. We have 6 workstations running Win 10 1709 & 5 running 1803.

    Finger Crossed!

    https://support.office.com/en-us/article/access-reports-that-databases-are-in-an-inconsistent-state-%EF%BB%BF-7ec975da-f7a9-4414-a306-d3a7c422dc1d?ui=en-US&rs=en-US&ad=US

    Tom

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-07-03T02:08:18+00:00

    I posted a whole bunch on my blog, see http://www.devhut.net/2018/06/13/access-bug-database-is-in-an-unrecognized-format/

    Thanks Daniel. Much appreciated.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-07-03T02:01:31+00:00

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-07-03T01:43:59+00:00

    It's just a registry key, try it, if you experience any issue simply switch it back.

    From what I've seen in this thread and others, the DisableLeasing hack fixed the issue.  In one case, one person started that although this worked, their databases were much slower.  No one else, that I've seen, reported any other issues.

    Daniel are you able to point me to any other threads with info on this issue?

    Was this answer helpful?

    0 comments
  5. Anonymous
    2018-07-02T19:39:37+00:00

    I'm glad you got on top of it in your situation but reinstalling Windows on many workstations and then disabling Windows updates isn't my idea of a fix in my situation. 

    I'm not holding my breath but MS should be all over this and be producing a proper fix ASAP.

    I'll know within a few hours if disabling leasing has worked and will report back here.

    Was this answer helpful?

    0 comments