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 No comments

604 answers

Sort by: Most helpful
  1. Anonymous
    2018-11-16T00:36:32+00:00

    I agree  totally  - what we need in Microsoft is someone like Steve Ballmer who realises it is all about convincing Developers that Microsoft are a company worth investing our efforts in. Hopefully someone will take this  seriously and fix it otherwise Windows 10 and its successor will be forever suspect.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2018-11-15T22:39:39+00:00

    Anxiously, waiting... : )

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2018-11-15T22:29:01+00:00

    Thanks Gina. We haven't tried using the ACCDB to see if that helps.

    Marty

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2018-11-15T15:42:25+00:00

    Shane, I find it almost unbelievable that you aren't able to reproduce this. This issue has been causing many people major issues for many months and and all you have to report is that you can't reproduce the issue? Hard to believe to be honest.

    I'll second that.  I've had six agencies (clients) who have had this issue and a possible seventh cropped up on Monday.  This reflects badly on us as developers as the users put the blame on us even though our applications have been running problem free for years up until this bug has  appeared.  It may not seem like a big deal to Microsoft but it's a big deal to those of us supporting applications who keep government and businesses up and running.  

    We've had to fight hard enough to be taken seriously when using Access to solve problems - don't make this more difficult.  The majority of my clients are law enforcement academies with small budgets and the testing/training management systems I supply are affordable and effective.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2018-11-15T11:56:19+00:00

    Hi bignose2, 

    that is basically almost the same situation. The only difference is OS on the server (irrelevant from my perspective) and number of client computers (we have approx. 20 of them at our site, as of now 10x Win7 vs. 10x Win10). 

    Our client computers do extensive reads/writes to the database, so corruption surfaces fairly quickly (the more PCs run 1803, the quicker/more often we get corruption). As you have said, your PC with Win10 1803 is not used much - that could still be a culprit to not triggering database corruption.

    Your point with single PC corrupting database while server having FE open makes sense, although it is new to me. It is still a problem in SMB Leasing implementation of the client computers where concurrency takes place. My example of 2 or more clients doing extensive work on the shared database backend would arguably cause corruption faster.

    Otherwise your situation is very similiar: PCs with Win10 1709 -> everything is ok. After upgrading to 1803 -> corruption. 

    At one point, we will be testing Win 10 1809, but it is hard to do it right in the production environment while having other things to work on.

    Was this answer helpful?

    0 comments No comments