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. Anonymous
    2021-01-15T16:41:21+00:00

    Hi Mark, David and Shane

    For the past few months, I downgraded my users to Access 2013 for my Access database app. The amount of data corruption issues did go down, but there are still issues with performance and data loss, especially with our current VPN.

    A database designer/analyst in another department suggested migrating the Access backend database to SharePoint, which he has done successfully with several of his Access databases. He says the performance & data losses has improved dramatically and has not encountered a data corruption issue on the backend databases since moving to SharePoint. Note he did mention that tables need to be converted to "list tables" when migrated to SharePoint and that the 2 GIG db limitation still applies in SharePoint.

    We will be having a follow up, "deep dive" meeting with this database specialist, to get all our questions answered and be assured this is a viable option which complies with company policies.

    George

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-11-11T16:30:12+00:00

    This famous bug strikes again at work after 3 normal months, "database is in inconsistent state". We do not have leasing disabled option or revert back the update as there are 10-15 users on the same server. Any help greatly appreciated, Thanks

    Was this answer helpful?

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

  4. Anonymous
    2020-09-17T07:54:00+00:00

    @ Kiwi_Mark

    Good luck! So far using the DisableLeasing hack on the client PC's "seems" to be working (no corruption as yet). But the DB in question gets very seasonal use, and only really starts getting worked in Oct, so we shall see....

    Was this answer helpful?

    0 comments
  5. Anonymous
    2020-09-09T00:38:47+00:00

    @Duncan B - we appear to have a similar issue. Although it does seem more stable with the backend file share on Linux than it was on the Windows 10 machine we were using last year. Have not tried the FileCache solution yet.

    Was this answer helpful?

    0 comments