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 No comments

604 answers

Sort by: Oldest
  1. Anonymous
    2018-07-03T02:01:31+00:00

    Was this answer helpful?

    0 comments No 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 No comments
  3. 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 No comments
  4. Anonymous
    2018-07-22T12:04:35+00:00

    We also applied the official Workaround on our Server 2016 and windows 10 stations. after te workaround the databases are working without any problem.

    Thanks!

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2018-08-13T12:51:46+00:00

    Had this problem months back, (nightmare waste of time) eventually worked out Windows so managed to roll back to 1703.

    I have avoided using the workarounds and rolled back each time

    However a few PC's have now updated to 1803 & even though rolled back, 2 days later it updated again so I am going to try & use the 1803 as I am going away & can't leave staff in this situation!!

    I have windows Home on a few PC's so can't easily prevent this update!!

    My most recent Windows 10 update still has the problem as of 13/8 so I DO NOT think any recent windows updates have helped.

    Going to try the disable leasing.

    My server PC does in fact run Windows 8, is is all the network PC's that run Windows 10 now,

    Just tested & it seems will need (not tried yet) to use disableserver on this windows 8 PC server as was corrupting.

    Whilst recommended, I was a little surprised as this server PC not being win 10, in all my testing before it was the client PC's on 1803 that caused the problems, the server always stayed the same.

    Not yet tried on server PC as tied up for a while but will report back.

    Was this answer helpful?

    0 comments No comments