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: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2021-04-23T15:05:51+00:00

    Repair software will do nothing for the current issue as Compact and Repair is all you need.  Software like Stellar Repair cannot help with the current Windows 10 bug affecting Access databases and sadly nothing has changed in 3 years now. 

    There are a couple known workarounds, you have to implement one of them, or better yet IMHO, migrate away from Access as a back-end.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2021-04-23T21:13:59+00:00

    We never put in place the workarounds.　

    It has been nearly 5 months since we have had this issue. And the queries that we know would cause an issue when multiple users were logged in, no longer generate the corruption error.

    I wonder whether there may have been an update that inadvertantly corrected the original problem.

    Has anyone tried removing the workarounds to see if the corruption has ceased?

    We are using Office 365.　 I will need to see what updates our IT put in place last November, December.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2021-04-23T21:27:53+00:00

    "And the queries that we know would cause an issue when multiple users were logged in, no longer generate the corruption error."

      >>> Which type of queries generated the corruption errors for your team ?

    Was this answer helpful?

    0 comments
  4. 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

  5. Anonymous
    2021-04-29T14:23:55+00:00

    This is like the "404 message" of the internet. 

    You are giving a solution to fix a corrupted file. Not a solution to keep the file from constantly getting corrupted due too changes made by Windows, and Office.  This rubber stamp answer is comical.

    Was this answer helpful?

    0 comments