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
    2019-11-27T19:15:36+00:00

    Shane what is happening with the elephant in the room though? We have still to see any permanent fix to the corruption issue......and contributors to this thread seem to be saying that the workaround is no longer working. Can you throw some light on that?

    The livelihood of people is at stake here.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2019-11-27T19:06:10+00:00

    Just in case people don't click through to Daniel's blog about the Query is Corrupt issue, we are getting fixes out for all channels as quickly as we can.  The update for Access 2010 and 2013 MSI installs are available now:

    2010: KB2986256

    2013: KB2965317

    Daniel, you might want to fix some of the text on your blog, e.g. "Microsoft’s fix isn’t scheduled to roll out until December 11th at the earliest!!!" 

    Shane Groff

    Access Engineering

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2019-11-27T19:05:28+00:00

    Sadly, you can only easily migrate the data, everything else is a complete rewrite!  So, no, no easy flip a switch and you're done.  It was almost a year (although there were some major additions made).  It has also offered a new world of tools, things that couldn't be done before and now is accessible from anywhere in the world as long as you have a browser.

    In this specific case, I went the route of using MySQL/PHP (with a framework) and everything else that it entails (html, css, javascript/jQuery, bootstrap, ...).  I will say it was challenging at times, but very rewarding and the final product exceeds my client's expectations.  So far, there has only been one area that is problematic, I can't automate Outlook.  I can generate e-mails, no issue there, but I can't start an e-mail and display it to the user for review/completion.  I've created a form with the elements (subject, body, ...), but it isn't exactly the same.  So far, that has been the only true issue.  Beyond that I have been able to everything I previously did and more.

    Was this answer helpful?

    0 comments No comments
  4. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

  5. Anonymous
    2019-11-27T18:17:50+00:00

    There have been no update that correct this issue ("unrecognized database format").  The status is unchanged from when it first surfaced more than a year and a half ago.

    I feel your pain.  I have lost several of my best clients due to the never ending bugs and the downtime they have caused/cost.  I did manage to salvage one very important client by migrating their system to a new Web based system.  Sad, they had been running their entire business on Access for the past 7-8+ years and it wasn't until O365 that problems arose that pushed them to run away from MS.  That said, although it required almost a year to accomplish, it was the best decision ever!  No longer tied to any vendors, can be hosted on any host, even internally, no issue with the number of user, can perform hot backups without issue, no longer impacted by all these Microsoft Updates, much faster, ...  This is the direction I am now promoting to the rest of my clients.

    Now with the latest blunder Query is Corrupt ... I have no words left.  If you haven't been hit by this, turn off automatic updates immediately if you are running Access 2010 or 2013 (MSI)!!!!  For the other version, be sure to ensure your systems are fully updated.

    Microsoft's responses just doesn't make sense to me, and God only knows what is truly going on in Redmond as Microsoft never communicates in any truly meaningful way with its users.

    Deep breaths ... that all we can do as we are all at the mercy of Microsoft (and they know it)!

    Was this answer helpful?

    0 comments No comments