This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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?
A family of Microsoft relational database management systems designed for ease of use.
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.
Wow! That's interesting. Thank you for sharing this. I will go back and check the application's queries to see if any of them fit this description. Any clues are helpful.
Consecutive appends to different tables does not seem to be an issue.
We did not look for consecutive appends to the same table. (Though there are several such scenarios in the database) But, likely it is not a problem or we would have seen it create the corruption issue by now.
Thanks, TQuasar! I'm going to try modifying our database application to reduce the number of consecutive delete/append queries and see if that helps to mitigate our issues.
You mentioned building in a delay; what method did you use to delay the processes? I can think of a couple of ways to do it but if you've got one that seems to work that would save me having to guess what's going to help. I do have a back-to-back series of delete/appends going on with tables via VBA.
I just had a user's database go down and I confirmed with them that they were indeed working on the procedures that trigger the delete/appends so your pinpointing of this possibility is the clue I've been waiting for. Thank you for sharing.
We have several locations with their own MSAccess database on a server and 15-30+ simultaneous users connecting via a frontend MSAccess database. It had been years without any such corruption until the end of 2018, when the corporation's IT began updating the window 10 computers with the 1803 version(s). Dealt with the issue intermittently over a couple of months. Was likewise hesitant to use the work around either on the server or the clients.
We were able to identify a combination of delete and append queries to the same table, back-to-back that would cause this issue. After we rearranged the queries and/or entered some delay between such, we have not had the issue re-surface for weeks.
Not sure if we are out of the woods yet, and still look forward to the "fix". But for now, addressing this by adjusting such back to back delete/append queries, seems to be working.
SO, just another piece of the puzzle that might provide some insight.
Thanks for the insight, TQuasar! In your experience, does the corruption occur with consecutive appends as well, or only when there are consecutive appends and deletes? I imagine it would be difficult to reduce consecutive appends in a multi-user environment.
Hi JAZShaefer!
Sorry for the delay in responding.
Most instances just required a reordering of the delete queries, so they were not immediately prior to the append query to the same table.
There was one instance where I used DoEvents between the queries, which seemed to alleviate the problem.
Hope that helps!