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-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
  2. 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
  3. 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
  4. Anonymous
    2020-04-22T07:30:23+00:00

    Thanks for the tip, Daniel !

    Was this answer helpful?

    0 comments
  5. Anonymous
    2020-04-22T07:41:11+00:00

    Ok, the batch file is doable since it's a one time process then reboot.

    Questions:

    1. Can you reverse the Client registry fix if necessary ?
    2. I have approximately 30 users who may use this database. So I have to coordinate this registry fix with all of them or else the database corruption continues ?
    3. Running the batch file as an Administrator will require entering an Admin pw on each user laptop, correct ? I may have to enlist IT Desktop Support to pull this off.

    I appreciate your assistance, Mark.

    George

    Was this answer helpful?

    0 comments