Forum Discussion

Mohindar_Malhotra's avatar
Mohindar_Malhotra
Copper Contributor
Mar 02, 2020

MS Access .mdb database Corruption

Major issue:
WE have an MS Access database application (Inventory Management System) that was developed few years back. We have been using this app in SBS 2008 without any problem for over 10 years. The DB is split in two parts, Front End (all logic) which is linked to Back End that has all the database tables. Recently (about a couple of weeks ago) we have migrated to Server 2019 VM and have started using above application. We are experiencing Back End database corruption on daily basis (See Error attached). This is becoming a major issue. I am just wondering if this is being caused by some Server Network stability/ configuration issue. Your thoughts/ help will be greatly appreciated to resolve this issue!

4 Replies

  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor

    Mohindar_Malhotra 

     

    It is quite possible that you are just now encountering this long-standing bug. The article to which I linked has information on it and a suggested work-around for it. MS has been aware of it for a long, long time, and we are all anxiously awaiting a more permanent fix. 

    If this does NOT resolve the problem, at least for the time being, post back.

  • Stacy Clark's avatar
    Stacy Clark
    Brass Contributor
    You can read the different ways to repair corrupt MDB file in this forum: https://dba.stackexchange.com/questions/71906/ms-access-mdb-ldb-database-corrupted
  • DJBB32's avatar
    DJBB32
    Copper Contributor
    We are seeing a similar issue with Windows server 2016 and access 2016 databases. The corruption only happens when connections are initiated from a windows server 2016 desktop.

Resources