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: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2020-02-02T17:05:22+00:00

    I had this same problem running our database over a mapped drive or UNC path from our server (SBS2011) after introducing Windows 10 machines and a new Server 2016. Randomly the database would corrupt or crash when using it. I scoured the logs and found it coinciding with group policy refreshing in the back ground. To test the theory i opened the database and ran 'gpupdate /force' hey presto, corrupt and crashed database. It wouldn't corrupt all the time mostly crash. So I used group policy to 'turn off background refresh'........worked a charm.

    1. Hold down the Windows Key and press “R” to bring up the Run command box.
    2. Type “gpedit.msc“, then press “Enter“.
    3. In the “Local Computer Policy“, go to “Computer Configuration” > “Administrative Templates” > “System” > “Group Policy“.
    4. Open the “Turn off background refresh of Group Policy” setting.
    5. Set this setting to “Enabled“, then select “OK“.

    Hope this helps someone.

    Has anyone tried this out ?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-02-24T16:09:17+00:00

    I tried this out and still getting corrupted back end tables

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-02-24T16:23:40+00:00

    Make sure the the 'reconnect' option box is unticked if you use the GPO drive map option. That will definitely fix it, did for me.

    Was this answer helpful?

    0 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
    2020-02-24T17:03:10+00:00

    This is killing me!  Microsoft really needs to start taking this more seriously.  I have "lost" roughly 10 customers over this problem and have many that have been instructed by their IT person or team to only have ONE user in the program at a time.  This is unacceptable!  I have tried every suggestion in this extensive thread with no success.

    I have decided to develop a program on a separate platform until this issue is fixed.  Microsoft has got to be losing hundreds of programmers and developers over this.

    Keep the suggestions coming.

    Jon Denney

    SAFE Software

    www.thesafeprogram.com

    You are preaching to the choir.  What makes this worse is that sometimes the recommended fixes work and then there is an update somewhere and we are back to square one.  I have partnered with another company to move my big money application to another platform.  It's not going to be painless though but I'm out - I cannot spend all day fielding calls on this issue.  Is anyone from Microsoft even monitoring this forum?  Hello?

    Was this answer helpful?

    0 comments