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
    2019-05-29T20:18:44+00:00

    The disable leasing fix works if applied on the server. You can alternatively apply the client registry change mentioned in this thread many times. Make the change below to each Windows 10 client PC that opens the database from a shared location. Then restart the client PC.

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters]

    "FileInfoCacheLifetime"=dword:00000000

    "FileNotFoundCacheLifetime"=dword:00000000

    "DirectoryCacheLifetime"=dword:00000000

    Both approaches have worked for me. The Windows 10 client change is usually easier to get approved for implementation on your clients network, so you might want to try that route.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2019-05-29T19:47:14+00:00

    So there is no fix other than moving from Access?  I just charged a client for this database and now how to tell them it won't work because of MS bugs and a serious issue that has been outstanding with MS for over a year???  What is the alternative?

    SO FRUSTRATING!  Agreed.  Totally unacceptable

    The DisableLeasing workaround mentioned many times in this thread works. The issue was driving me insane for a couple of months with one client until I asked their IT contractor to employ the workaround on their server. I've had no problems since.

    Apparently the workaround also works if applied to all client machines rather than the server.

    Any yes......it is totally unacceptable that after all this time MS is still floundering around and not providing a proper fix.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2019-05-29T19:38:24+00:00

    So there is no fix other than moving from Access?  I just charged a client for this database and now how to tell them it won't work because of MS bugs and a serious issue that has been outstanding with MS for over a year???  What is the alternative?

    SO FRUSTRATING!  Agreed.  Totally unacceptable

    Was this answer helpful?

    0 comments
  4. Anonymous
    2019-05-23T08:55:55+00:00

    Tried all the fixes, got all the updates, front end on latest windows 10 build and backend on server 2016.

    nothing works, the database is now getting corrupt so often that it is unusable and we are having to look to moving to alternative non microsoft software.  need an immediate update to fix this problem but since Microsoft have known about this for around a year and done nothing about it then i'm guessing they wont, this is unacceptable.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2019-05-20T15:48:02+00:00

    Look forward to hearing about your results.

    Was this answer helpful?

    0 comments