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: Most helpful
Most helpful Newest Oldest
  1. 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

  2. Anonymous
    2020-01-10T02:27:20+00:00

    Hi Carlos,

    Our Access database will be going away in the near future, so it wasn't worth the effort trying it convert it to SQL Server. I have been waiting to have our IT Support to implement the Disable Registry hack fix to our BE host server, but they move at their own speed.

    I came across a simple fix by accident: Created a subfolder below where my BE database file was, move the db file to the new subfolder then relink my FE to the BE tables' new location. That was Monday, and so far, no database corruption issues. I'm not sure why, but I'm not complaining. Gives me some breathing room until IT Support applies the fix.

    George

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-01-09T20:45:09+00:00

    Hi Daniel

    Im one of those that decided to migrate our DB (32 users) to SQL Server Express, got fed up with the corruption issues with no MS solution in the near future.  Its been working just fine for the past 6 months, no more calls/complaints from users.

    Based on your comment  "will require some changes to work efficiently." , can you share what are those? 

    Thanks

    Carlos

    Was this answer helpful?

    0 comments
  4. Anonymous
    2019-12-14T21:05:16+00:00

    Migrating to SQL server or Azure is relatively straightforward, but will require some changes to work efficiently.

    A true Web based system, well that's a whole other can of worms.  This is a serious undertaking, especially when just starting out.  My conversion, of a medium complexity databases, took about 6-8 months, although now I could probably do it in 2-3 months. At least 1 month was adding new features.  There's a huge learning curve (html, CSS, JavaScript, jQuery, MySQL, PHP, PHP framework, ...).  So I'm not saying it's easy, but the payoff is huge and stability is worth its weight in gold!!!!

    Was this answer helpful?

    0 comments
  5. 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