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
  2. Anonymous
    2020-07-09T22:51:51+00:00

    Not sure what's going on there. Many users have found that the server reg fix stops the problem in its tracks as it did for me over 12 months ago. A client was experiencing daily corruption. After the IT contractor applied the server fix there have been no issues since.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-07-09T22:56:29+00:00

    Be warned - Performance can be affected dramatically by the server fix. That happened in my case until I had IT remove the fix after numerous complaints. The client side fix didn't work for me. Note that these are developer solutions, not MS solutions, which may or may not work. After 8 months, I had to go with the last resort which wasn't suggested here but by a couple fellow Access developers who went through the same database corruption issues. It's basically trial and error while the level of user complaints rise. I had to find a permanent solution.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-07-09T22:59:10+00:00

    Like I said, what might work for you, might not work for someone else. These are developer suggestions.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2020-07-09T23:01:36+00:00

    Yes, fair enough. Perhaps it depends on the individual server setup whether performance is affected. 2 of my clients have employed the server fix without any performance hit that is obvious. I am regularly connected to both of these systems via remote desktop and they both perform well.

    I suppose there has to be a reason why some servers suffer from the performance hit and others don't.

    Was this answer helpful?

    0 comments