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-19T23:53:23+00:00

    So I tried a new DB and linking to the data in the old one and that still won't work. I still cannot open my database. if I can't get this solved, i'm going to return this machine and then not ever get a PC again! I have nothing but problems with PCs.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2019-11-07T22:15:33+00:00

    You definitely have a different issue than this tread is about.

    You should search for recovering a corrupt DB. Sometimes you can start a new DB and link -import from the corrupt DB.

    A quick search found the following link it looks like it has the few easier ways to hopefully fix the existing DB

    http://www.accessrepairnrecovery.com/blog/recover-corrupt-databases-access-server-without-losing-data

    Usually the easiest way is to restore from a backup and recreate the data since that restore point.

    Good luck

    Thank you, I will look at that link. The weird thing is that the DB is perfectly fine on my other Windows 10 machine. I just copied the DB and put it onto my home computer with Windows 10 and I can't open it and get that error. Like I said, I will check out that link.

    Thank you!

    Stephanie

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2019-11-07T21:37:21+00:00

    You definitely have a different issue than this tread is about.

    You should search for recovering a corrupt DB. Sometimes you can start a new DB and link -import from the corrupt DB.

    A quick search found the following link it looks like it has the few easier ways to hopefully fix the existing DB

    http://www.accessrepairnrecovery.com/blog/recover-corrupt-databases-access-server-without-losing-data

    Usually the easiest way is to restore from a backup and recreate the data since that restore point.

    Good luck

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2019-11-07T20:58:41+00:00

    Ok so they are added as new lines and I rebooted my machine. The issue still persists. I would try repairing and compacting it, but doesn't that require the ability to open the DB? It won't let me even open it, I just get that error.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2019-11-07T20:45:09+00:00

    Yes they are normally new lines. I believe the computer needs a reboot.

    If you are still having the same error, it may be a different issue than the one in this thread.

    The issue here is random lockup and a compact - repair fixes the problem for a while. Have you tried to compact and repair the DB?

    Was this answer helpful?

    0 comments No comments