This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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?
A family of Microsoft relational database management systems designed for ease of use.
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.
So far the registry change on the Windows 10 client has fixed it for my user. She is no longer reporting the error. But it is regrettable that Microsoft hasn't addressed this problem. It's a big problem for companies that build Access solutions and companies that rely on Access to get work done.
For God's sake Microsoft! Fix this. It's been a year now and every damned day I have to deal with the same issue from a different location. I have 30+ law enforcement academies that use an Access application and they rely on it. The cost in lost productivity and the cost in lost credibility is not insignificant. Agencies are reluctant to apply the "fix" which means that I get daily requests to get their systems back up and running.
I am a contractor developer and do not have the permissions or scope to apply server fixes which means contacting their IT which means the old "We don't support Microsoft Access applications" routine and only adds to their suspicion of the product.
This alone may drive me into retirement.
We continue to gather information from customers, and are testing a new approach.
This is not a simple issue, and in addition to the difficulty of isolating the problem, we also have to be careful not to introduce new issues.
The initial fix we tested for this problem introduced new issues that were worse than the original problem.
We are working on this, and I will post updates when I have more concrete information.
Shane Groff
Access Engineering
I agree it should be fixed by Microsoft. But in the interest of giving you and your clients some relief, I would urge you to try the client side registry change that has been suggested. It seems that is working for my clients without any downside so far. Also does not require a server change. Disable leasing on the server does work, so I suggest both to my clients, but the Windows 10 PC changes to the registry below seem to do the trick. 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
We continue to gather information from customers, and are testing a new approach.
This is not a simple issue, and in addition to the difficulty of isolating the problem, we also have to be careful not to introduce new issues.
The initial fix we tested for this problem introduced new issues that were worse than the original problem.
We are working on this, and I will post updates when I have more concrete information.
Shane Groff
Access Engineering
Shane, thank you for responding. It is encouraging to know that this is being addressed and we are all hopeful for a resolution in the near future and appreciative of your efforts. Meanwhile, I'll be dreaming of retiring to an island...