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
    2020-02-24T16:09:17+00:00

    I tried this out and still getting corrupted back end tables

    Was this answer helpful?

    0 comments
  2. 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
  3. Anonymous
    2020-02-02T13:50:51+00:00

    Thanks Mark

    Thats really helpful

    I got this to work in ’Inno setup’ by creating a section in the setup file for [Registry] settings.

    Much handier than running a batch file.

    Is the consensus that these registry changes method is the unofficial fix?

    Has anyone had a failure with this option especially with VB code rather than an Access frontend?

    My VB6 program install file will include the new registry modifications and 

    I will be testing this with users from this Monday onwards. I will post updates as I progress.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-02-01T17:09:18+00:00

    I don't know the answer to that.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2020-02-01T16:12:40+00:00

    Hi Mark!

    Is it possible to clear these caches within VBA periodically, without needing to disable them altogether?

    Thanks!

    Was this answer helpful?

    0 comments