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-03-30T07:17:40+00:00

    Some of the speed problems reported here are not caused by this fix - they are just bad programming practices and are muddying the waters, preventing a genuine fix being adopted. 

    Well, what can I say ?

    Did you see any sample codes of this bad programing to share with us ?

    But lets say you are right. And there is a bad programing with dlookups inside queries etc ...

    Why with Server fix, this "bad programing" is performing faster than in client fix.

    Doesn't this means that there are some speed issues with the solution of client fix ?

    PS

    Have to say that client fix is definately a fix and is working perfectly, just like the server fix.

    And I personnaly insist that in many cases, described above, including JDBC connections, client fix is having speed issues and not always with bad programing. But if if works for you ... it is ok

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-03-30T01:16:17+00:00

    Thanks mgnagle - Sounds like a good solution, but I'm not allowed to make registry fixes on users' laptops, which is why I'm trying to contact the right IT Support Dept in my company (Huge company). Once I can discuss your and others' fixes with this dept, I can get it reviewed, tested and implemented.

    What are your thoughts on Access 2013 users still accessing an Access 2016 database, while mostly Access 2016 users are accessing the same database concurrently (backend db is on a network) ? Can this situation causing data corruption issues also ?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-03-30T00:54:17+00:00

    Save you business and your sanity by implementing the very simple CLIENT SIDE fix on EVERY window10 computer - windows 7/8 do not need it but you could also apply it to those without problems.  Some of the speed problems reported here are not caused by this fix - they are just bad programming practices and are muddying the waters, preventing a genuine fix being adopted. look back in the thread for the fix but here it is again for the 100th time on this stream.

    Put the following into a .reg file and run it as Administrator on each Windows 10 computer accessing the databases. Reboot each. The corruption you are experiencing will be a thing of the past.

    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
  4. Anonymous
    2020-03-29T20:37:57+00:00

    Well, my fix of changing the backend database to another subfolder and refreshing the front end database tables links worked ok for the past couple months, until the Coronavirus pandemic hit, and everyone started working remotely. So, I'll be reviewing the fix options posted here previously and discuss with the right IT Support team, if I can ever find them, which fix(es) would work best for us. BTW, which fixes are looking like the best ones long term ?

    In the meantime, I have a question. I believe most everyone in my department were upgraded last year from Windows 8/Office 2013/Access 2013 to Windows 10/Office 2016/Access 2016. However, if there are still two or three users who didn't get upgraded, could they also be causing this frequent data corruption issue, which has become a daily event for the past couple weeks ?

    Thanks for your feedback and suggestions,

    George

    Was this answer helpful?

    0 comments
  5. Anonymous
    2020-03-10T10:20:12+00:00

    Did you apply the registry hack?

    Was this answer helpful?

    0 comments