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: Oldest
  1. Anonymous
    2020-07-15T18:21:38+00:00

    Daniel, you are correct.  The implication in the earlier rant (not mine) was that our applications are "simple desktop" applications which doesn't begin to describe the things we as developers are creating.  In my case I know that my main application that is in use in 40+ different agencies has a limited life span and I've been asked to consult with a government agency to replace it.  I will make money consulting but by essentially putting myself out of business on that particular front.  In my case I'm working toward retirement so it's not a big an issue as with other developers.  

    But there is always going to be a need for accessible and affordable solutions and I maintain that Access is still a great tool for that.  I also have several other complex applications that will most likely outlive me. I would prefer to keep an amicable relationship with the people like Shane who are trying to help rather than pound my desk making demands. 

    We would do well to focus on answers from management - any ideas on that?

    Our reputations do not need to suffer if you approach this problem with your users in a calm and helpful manner.  So far no one has faulted me nor abandoned their applications.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2020-07-15T19:52:27+00:00

    I haven't explicitly been faulted, but have had several clients decide they were done with Access over this, and other bugs that cost them thousands in downtime, and simply go to other development companies (didn't even get the chance to quote on the project and these were long term excellent clients of mine - that alone tells me who they are blaming at this point).

    So they don't directly blame me, but they have taken their business elsewhere.

    And just because they don't say things directly to me, that doesn't mean this doesn't hurt my image/reputation as i was the one who recommended Access, and since they've decided to go elsewhere, do you really think they're going to recommend my services to others.  So at the end of the day, this bug (and others) have cost me clients, and the potential for future work and/or referrals.

    I truly don't think Microsoft understands the black eye that these continual bugs have given the product and as a consequence developers.

    Enough said.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2020-07-17T07:05:11+00:00

    I have a situation where 4 networked PCs have just been upgraded to new hardware. They were previously running Windows 7 and there were no issues.

    One of the PCs, the "Admin" machine hosts the data file and the database frontend on that Admin machine and the database frontends on the other 3 PCs points to the data file on the Admin machine.

    Corruption has started to occur with the new hardware running Windows 10. What is the best approach? Should the client reg fix be applied to all machines?

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2020-07-17T09:28:54+00:00

    The easiest solution is to run Microsoft's official workaround, the server reg hack.  One computer (the server/PC that hosts the back-end file), one time.  If you experience issues, then you can always explore other options.

    https://www.devhut.net/2018/06/13/access-bug-database-is-in-an-unrecognized-format/

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2020-07-17T09:39:38+00:00

    Thanks Daniel. I'll do that.

    Was this answer helpful?

    0 comments No comments