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
    2020-05-13T18:08:08+00:00

    I have Repair and Compact option on Close checked in my backend db, which helps with the bloating. I agree with Daniel on importing your db to a new blank db from time to time, to keep the size in check.

    Btw, my switching to another backend folder has been working out ok for the past couple weeks. Only one corruption incident so far.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-05-13T17:43:04+00:00

    I know this is an old thread, however I am hoping that you can still help with this issues. I have one doing this and it does bloat while in use, is this something that I can stop?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-04-29T16:18:03+00:00

    Ok, I was able to access your link today. Not sure why I couldn't see it yesterday.

    Question - If my database is on a NAS, would this client registry fix still work ?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-04-28T19:13:45+00:00

    You mean the file caching workaround ?

    What about the client side registry fix ? Is that also a hit or miss solution ?

    George

    Was this answer helpful?

    0 comments
  5. Anonymous
    2020-04-28T18:58:39+00:00

    The performance and mapped drive issue doesn't impact everyone equally.  So you may be one of the lucky ones where everything runs smoothly.  You won't know until you try.

    I haven't heard of any issues regarding the file changing workaround.

    Was this answer helpful?

    0 comments