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: Newest
  1. Anonymous
    2020-01-28T19:42:12+00:00

    So with each update, you have to reapply the registry fix after the update and hope it'll still work ?

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2020-01-28T19:01:21+00:00

    Some of my clients had applied the registry fix and were stable for a while but it appears that the last Windows 10 update may have reversed that because suddenly I've been inundated with another rash of calls.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2020-01-28T18:43:45+00:00

    Good luck, Jaz ! I was in the same situation over 3 weeks ago. Calls/emails/texts every day, angry users at my desk, etc.

    Boss had no suggestions, IT Support was unresponsive even though they caused this issue with the recent upgrade to Windows 10/Office 365. This fix saved my a**. Try it. If it doesn't work, go for the server fixes. But I think it'll work.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2020-01-28T18:33:59+00:00

    I created a subfolder below where my backend database used to exist then moved it there (on the same server). Once moved, I relinked the FE to the back end tables' new location and set the "Compact/Repair on Close" option. I cannot say if the folder move, relinking the back end tables and/or the Compact/Repair on Close is what fixed it, but it is fixed. Over 3 weeks later, no data corruption errors - Knock on wood. Sometimes the simpler solutions are the ones you try last. 

    I just tried this on a user's system.  Fingers crossed and I'll report back if they stay stable for a week or so.  I'm sick of getting these calls every day; I have a large number of clients so it really adds up in time down the drain not to mention the loss of goodwill.  (Sorry about the whining.)

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2020-01-28T18:07:56+00:00

    Correction: relinking the BE tables to the FE database...

    Was this answer helpful?

    0 comments No comments