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
  1. Anonymous
    2019-11-07T18:27:04+00:00

    This is what I and many have done and I have not heard of anybody that it has not worked for.

    Here is the registry change to apply to ALL Windows10 "Clients"

    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?

    0 comments
  2. Anonymous
    2019-11-07T18:45:49+00:00

    I agree with RonNeer. The Windows 10 client registry changes he mentions have worked for me and my clients. Disable Leasing on the server will also work, but is met with resistance from IT pros and has other possible side effects.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2019-11-07T20:04:54+00:00

    This is what I and many have done and I have not heard of anybody that it has not worked for.

    Here is the registry change to apply to ALL Windows10 "Clients"

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

    Thank you for this! Are the last 3 lines new parameters I need to put in in addition to the ones currently there?

    Thank you!

    Stephanie

    Was this answer helpful?

    0 comments
  4. Anonymous
    2019-11-07T20:15:41+00:00

    If they were new lines i needed to add to that particular registry entry.....I did add them as 3 new entries and I still receive the same error when trying to open the Access Database. 

    If you'd prefer me create a new thread, i'll certainly do so if needed.

    Thanks!

    Was this answer helpful?

    0 comments
  5. Anonymous
    2019-11-07T20:45:09+00:00

    Yes they are normally new lines. I believe the computer needs a reboot.

    If you are still having the same error, it may be a different issue than the one in this thread.

    The issue here is random lockup and a compact - repair fixes the problem for a while. Have you tried to compact and repair the DB?

    Was this answer helpful?

    0 comments