Access 2010 mdb (2003 file format) corrupts on 2008R2 Virtual Server ESXI 5.5
Posted on 2014-12-09
We migrated from a physical environment to all Virtual environment (ESXi 5.5) on HP C7000 Chassis with HP Virtual Connect, BL460c Gen 8 Blades direct connected to a 3PAR 7200 SAN last month. Since we have migrated all of our Access 2010 mdb (and mde) database are constantly getting corrupted. We have to get the users out and Compact/Repair sometimes 6 times a day for each of 7 production databases.
I have one mdb that runs nightly vba code and emails out reports at 2am that has never had a corruption problem until now. It only has 1 user and most of the linked tables are SQL Server tables. It does however create numerous temp tables for reporting purposes. This morning during the scheduled script, the database became unrecognizable, I did a compact / repair and then I noticed that one of the tables was completely missing! had to restore from a backup.
We have opened tickets with Microsoft, HP Blades, HP Virtual Connect, 3Par all to no avail.
Anyone else having problems with corruption of Access mdb and mde files running on VMware ESXi 5.5?