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
    2020-04-28T04:45:14+00:00

    Daniel,

    What exactly does the client registry fix do, and why does it resolve this Access database corruption issue ? Before I recruit a tech with admin rights and we proceed to update 40-ish client laptops, I want to have some assurance this fix will work.

    Let me know - Thank,

    George

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2020-04-28T04:40:09+00:00

    I must have misunderstood your posts. I thought you said you had been running on an .accdb front end db and a back end .mdb successfully for the past couple months, without data corruptions.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2020-04-28T04:16:57+00:00

    Hi Everyone - ie fellow crash victims . .

    On our system we have a main backend DB that was stored in a seperate RAID harddrive box. - It floated between 200meg and 300meg in size and was stable with 20 users.

    After we installed a new server box HP Proliniant ML350, we moved the backend tables to a Raid array inside the server box. It did run faster, but we also started experiencing the corruption issues. 

    most commonly around 8.30 - 9.00 am as staff started logging on. sometimes it would crash several times in 1 day.

    we tried fixing networks points - cables - switches etc - thinking it was some sort of packet crash causing the corruption. . . nothing worked.

    about 6 weeks ago i moved the BE tables back onto the external RAID box - and have not had a crash since . .  

    The big question is WHY . .  mysteries of the universe . . 

    Cheers

    PaulG

    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
    2020-04-27T19:44:34+00:00

    Bad news - The switch to .mdb hasn't stopped the data corruption issues. My database has corrupted twice since I implemented the change.

    I am now considering Plan B - The client side registry fix. However, I am curious what exactly this registry fix does if someone could explain.

    Thanks,

    George

    Was this answer helpful?

    0 comments No comments