MS Access .mdb database Corruption

[Mohindar_Malhotra]

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!

[#2]

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.

[#3]

Hi @Mohindar_Malhotra 

As per the attached error message, your database is in an inconsistent state. 

[#4]

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

[#5]

@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.