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
    2018-12-26T03:46:26+00:00

    I just started having this issue as well. The MO is the same. 

    I have one site that has their database on a Windows 8.1 in a share file that my users with 1803 corrupt the database.  

    However same database put on a Synology NAS in another site has no such problem.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2018-12-17T12:20:02+00:00

    Hi,

    Really, really, don't take my experience as anywhere near to being properly tested (my disclaimer) but as per a reply I did on the 18th November I have found 1809 to work.

    I tested on two different PC's that previously did cause the corruption and with 1809 is was not.

    However I have not fully integrated into my LAN as I found the workaround OK for me, small 3 PC LAN and left alone on 1803.

    Basically you never know what 1809 will introduce as possible NEW bugs so felt best leave alone for a while but I would be fairly confident is would work but as no one else seemed to have said this I am more than a little cautious although since pulling the update you have had to force the 1809 update and does not seem like many are getting it automatically.

    I suspect something was done with networking as with 1809 I found that other PC's on the lan were not always visible in file explorer. Age old problem with often a variety of causes so could be unrelated but on 1809 the only way I could see some other PC's on the lan was to directly type \HomePC\My Docs .... etc.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2018-12-17T11:33:22+00:00

    What patch? To my knowledge Microsoft has yet to even identify the issue, little alone provide a fix. According to the official page on the subject (last updated in June!) It is still in workaround status, see https://support.office.com/en-us/article/access-reports-that-databases-are-in-an-inconsistent-state--7ec975da-f7a9-4414-a306-d3a7c422dc1d

    As for the slowdown you reported after applying the registry hack, your not alone, many have stated the same things.  Sadly, there doesn't seem to be any solution to that issue either.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2018-12-17T04:25:39+00:00

    I have applied the DisableLeasing modification and it works but it is slowing down considerably the network access. 

    Some part of my application are almost not usable at all now while it was working perfectly fine before the 1803 update.

    Do you know if the patch has been applied to the 1809 update, I would like to apply it and then get rid of the DisableLeasing correction?

    Thank you

    S.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2018-12-07T15:34:07+00:00

    Yes; I have had difficulty deleting the .laccdb file a few times.  I believe it is due to another problematic Windows 10 machine which appears to have the file in use and will not allow it to be deleted.  As I mentioned previously the log and transaction reports always indicate there is a client machine involved that has not had the registry fix applied.  At least I am able to quickly ID the offending client machine now.  The .laccdb is 0 KB and appears to be corrupt.  In a few instances I have found that if I cold boot the offending client machine it appears to release the .laccdb.  However; most of the time I can delete the lock file.  

    On a least one occasion I had to enlist the help of the IT guys who have administrative rights on the network to kill the lock file.  In all instances once the lock is gone the repair runs uneventfully but there never seems to be missing or corrupt data in the repaired back end database.  It appears to me the focus should be on the .laccdb and what changes Microsoft made in the 1803 release.

    Was this answer helpful?

    0 comments No comments