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: Newest
Most helpful Newest Oldest
  1. Anonymous
    2020-04-22T07:30:23+00:00

    Thanks for the tip, Daniel !

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-04-22T07:28:26+00:00

    That may be what is occurring. The problem is knowing when the data corruption occurs, so you can quickly shutout the users & start repairing. Maybe implement a text or email alert ?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-04-22T07:20:00+00:00

    Interesting. I'll have to give this a try. I did move the .accdb to another folder on the network, which worked great for a few months. Then the Coronavirus/Work at home situation put a nix on things then the daily database corruption issues started happening again.

    Really wish MS would come out with a permanent fix, instead of all these workarounds. Access is a great, inexpensive db solution and VBA isn't a major pita to learn. I really hope MS isn't giving Access a slow death like FoxPro (that was a great product too).

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-04-21T14:49:54+00:00

    I incorporated the registry change into my setup program. I use the Wise Installation System, but am in the process of switching to InstallAware soon. Both have a scripting language that includes a command to update the registry. My current setup does require running the setup.exe as administrator. I don't have any VBscript code to give you to accomplish the same thing. However, you can place the commands into a .bat file and execute that. As described in other posts, you need to make the registry change on each Windows 10 client PC that uses the database in question.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2020-04-21T14:19:12+00:00

    Don't forget that corruption can also exist outside of the current bug and such corruption can lead to data loss.  Corruption is unpredictable.  I've seen entire databases corrupted beyond any recovery.  This is why backups are critical!

    Running any Access database over VPN is asking for trouble and corruption.  Access is ONLY meant to be run over a LAN.  Everything else is a risk, VPN is one of the highest risks for encuring corruption just by its nature.

    You should always make a backup prior to compacting.

    Was this answer helpful?

    0 comments