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-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 No comments
  2. Anonymous
    2020-05-03T21:47:40+00:00

    Well, I reverted the backend db from .mdb back to .accdb, moved my .accdb be database to another folder, then relinked the front end db to the new be's new folder location. Recompiled the fe to .accde and distributed to clients' desktops. This was after I reached out for IT Support and received no response.

    So far, the move to another be db folder trick seemed to be working again. Four days, no database corruption. I may have to fall back on the client side registry fix or disable leasing option if the database corruptions pop up again, but after a month and a half of daily db corruptions and no help from IT, It's good to find something that finally works again.

    George

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No 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 No 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 No 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 No comments