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: Newest
  1. Anonymous
    2021-03-05T09:07:08+00:00

    Another solution is Citrix: I do not recall it being discussed in this thread, See Access - Bug - Database is in an Unrecognized Format | DEVelopers HUT (devhut.net) thread starting 1st Feb 2021.

    But I guess this is much the same as running the front end on Terminal Server, which I think has been discussed here.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2021-02-26T17:13:07+00:00

    Thanks for the advice, Dave. After significant research, I decided SharePoint isn't the option I'm looking for. Perhaps SQL Express or SQL Azure may be.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2021-02-26T10:10:32+00:00

    I found this article - Thoughts ?

    https://sharepointmaven.com/how-to-overcome-sharepoint-5000-item-limit-threshold/

    I think you would be far better off spending the time converting to SQL Server Express or SQL Azure, rather than fighting with a tool designed for a completely different job (document management). And if your database just happens to be primarily for document management, then perhaps abandon Access and design a proper Sharepoint system.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2021-02-12T19:06:35+00:00

    Tom, please define what you mean by "real database work" when we are referring also to Access. Many database designers/developers don't consider Access a "real database" and strongly suggest fully converting to SQL or Oracle as soon as possible.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2021-02-12T18:45:04+00:00

    David, I have been researching this as a possible option but am not sold on it. If it proves to be an ineffective solution, I will no longer pursue it.

    I find it ironic that Microsoft views a potential solution negatively when they have done basically nothing to effectively fix this Access data corruption issue for the past 3 years.

    Was this answer helpful?

    0 comments No comments