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: Most helpful
  1. Anonymous
    2018-12-07T14:36:38+00:00

    Thanks for the detailed description that identifies unequivocally where the problem lies. Surely this is enough for Microsoft to work on to get a solution that does not involve making registry changes that can have undesirable side effects on some systems and cannot be implemented on large sites that have servers shared across many departments where the IT department, understandably,  do not want to risk compromising other functionality. 

    I can confirm that in all cases I have seen there is actually no corruption in the database itself - it is just in a state that is not recognised by the front ends. Typically corruption results in missing indexes and broken relationships but i have never seen this. The fix is to open the database with the full version of Access, agree to the repair, and the database is accessible again. I suspect a bit has been flicked, perhaps in the .laccd as you suggest)

    The fix is so simple that I have explained this procedure to customers so they can "fit" it themselves, but it is not a good look and may result in them eventually using it when it is not appropriate and there is a genuine corruption!!

    Spot on!  I had another site this week that had to be patched and the .laccdb file was persistent and contained garbage characters each time.  At least give us a way to easily delete persistent locking files.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2018-12-07T02:16:28+00:00

    Thanks for the detailed description that identifies unequivocally where the problem lies. Surely this is enough for Microsoft to work on to get a solution that does not involve making registry changes that can have undesirable side effects on some systems and cannot be implemented on large sites that have servers shared across many departments where the IT department, understandably,  do not want to risk compromising other functionality. 

    I can confirm that in all cases I have seen there is actually no corruption in the database itself - it is just in a state that is not recognised by the front ends. Typically corruption results in missing indexes and broken relationships but i have never seen this. The fix is to open the database with the full version of Access, agree to the repair, and the database is accessible again. I suspect a bit has been flicked, perhaps in the .laccd as you suggest)

    The fix is so simple that I have explained this procedure to customers so they can "fit" it themselves, but it is not a good look and may result in them eventually using it when it is not appropriate and there is a genuine corruption!!

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2018-12-06T23:27:02+00:00

    Our experience.  We have struggled with this issue for several weeks.  There are over 50 Windows 10 64 bit clients on the network as well as several Windows 7 machines.  The client machines communicate with the back end residing on a Windows 2012 server.

    The Access application was enhanced to track user login/logout activity and an audit trail to report on detailed transaction activity.  

    The recommended workaround was applied to the server and two of the problematic Windows 10 machines.  This appeared to resolve the matter but after a few days the database crashed once again.  A review of the login/logout activity indicated another user on a Windows 10 client missing  the recommended workaround opened the database.  Four seconds later a user on one of the stable Windows 10 machines; who was already logged in; attempted to run a routine that utilized an update, append and delete query in rapid succession.  The back end was once again corrupted.

    The IT department was encouraged two weeks ago to apply the registry fix to all client machines that had not had the workaround applied and to confirm updates were current.  The application has run smoothly since that time.

    Question:  Is the standard "unrecognized database format" message raised by Access related strictly to the back end database or could it be that it is the lock file (.laccdb) that is the root of the problem?  Is it possible the lock file is raising the error message and the back end is not actually corrupt?  We have noted after a crash the .laccdb has to be manually deleted before a repair can be run on the back end but have not found any missing data in the repaired back end.

    Was this answer helpful?

    0 comments No comments
  4. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

  5. Anonymous
    2018-12-04T14:34:42+00:00

    Has anyone heard anything new in regards to this issue?  Now users at my job are not seeing updated records, which is leading to distrust in the system that we had for years now.  One user will see an updated record, while another will not.  It also seems like the Windows update system is contributing to this matter of inconsistent data. We have updates delayed on all of the machines, but some computers have 1803 while others have 1703. I guess the 1803 people are crashing the database for the other users.

    Thank you for posting that.  I've had a site that recently started reporting records not being updated (or just plain missing) in a previously stable database.  They haven't had the crashing though but at least you've given me a clue as to where to look for the problem.

    Was this answer helpful?

    0 comments No comments