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
    2019-05-14T14:32:29+00:00

    We have several locations with their own MSAccess database on a server and 15-30+ simultaneous users connecting via a frontend MSAccess database.  It had been years without any such corruption until the end of 2018, when the corporation's IT began updating the window 10 computers with the 1803 version(s).  Dealt with the issue intermittently over a couple of months.  Was likewise hesitant to use the work around either on the server or the clients.

    We were able to identify a combination of delete and append queries to the same table, back-to-back that would cause this issue.  After we rearranged the queries and/or entered some delay between such, we have not had the issue re-surface for weeks. 

    Not sure if we are out of the woods yet, and still look forward to the "fix".  But for now, addressing this by adjusting such back to back delete/append queries, seems to be working.

    SO, just another piece of the puzzle that might provide some insight.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2019-05-14T04:42:32+00:00

    Yes, I agree. This Client side registry fix is the best resolution - it just needs to be applied to each CLIENT. Not sure why the "disable leasing" on the server side is still being touted as the only temporary fix on Microsoft's site - it is known to have side effects and does not always work. My understanding and experience is the client side registry fix always works and is very simple to apply.

    Has anyone else tried this, and I mean having applied it to every workstation accessing the data,  and not have it work?

    Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters]"FileInfoCacheLifetime"=dword:00000000"FileNotFoundCacheLifetime"=dword:00000000"DirectoryCacheLifetime"=dword:00000000

    I suggest trying it.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2019-05-13T22:20:45+00:00

    The only other thing I can suggest is the client side registry change mentioned numerous times in this problem. I have incorporate this into my application setup and it seems to be working. This can be done on each Windows 10 PC and then would not require the server change to disable leasing. Restart the PC after making the change and do it on every Windows 10 PC that uses the database. The only downside is that it only takes one Windows 10 PC without these changes to corrupt the database again. 

    Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters]"FileInfoCacheLifetime"=dword:00000000"FileNotFoundCacheLifetime"=dword:00000000"DirectoryCacheLifetime"=dword:00000000

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  4. Anonymous
    2019-05-13T15:59:54+00:00

    Balking, why?  It is on Microsoft's official website as the only workaround. What more do they need.  There's an issue, MS has official provided a workaround, ...

    Don't get me wrong a year to address this is absurd!  Absolutely absurd, but the workaround has been around since the beginning and it does "resolve" the issue.  Beyond that, it's a waiting game.  Who knows, it could be another year.  Show management the official MS webpage and get them to get IT to implement it.  There's little else you, or anyone, can do.

    Good luck.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2019-05-13T15:35:27+00:00

    Any good news to share?  I am now devoting at least an hour every morning to remoting in to user's sites to get them back up and running.  Some of the IT departments are balking at the disable leasing option.  There was every expectation that my company's legacy Access application (used in many law enforcement academies) was to be phased out but the replacement system built by another company has failed to deliver and now my users are still dependent on this Access application and I'm stuck with having to deal with this several times a day.  I need to be able to speak intelligently to them about how we are going to ensure stability.  Any suggestions on how to calm their fears would be greatly appreciated.

    Was this answer helpful?

    0 comments No comments