vba - Recent rash of Microsoft Access database files in an inconsistent state

Question

A large number of our clients operating a split front end/back end Microsoft Access application we built are encountering frequent but intermittent database file corruption issues. When the back end file is opened this message appears: "Microsoft Access has detected that this database is in an inconsistent state, and will attempt to recover the database … "

Opening the database with DAO using Visual Basic code results in error code 3343, "Unrecognized database format."

The repair attempt succeeds and we have not witnessed any data loss or dropping of primary keys, indexes, or relationships. Most cases involve where the back end file is located on a shared network drive. Some searches suggest that the latest Windows 10 update 1803 is suspect. Has anybody else encountered this?

Answer 1

It has recently been reported several times. A very thorough coverage of this issue can be found here.

Strangely, the cure can - at least for some cases - be found in old support threads:

Moved to Server 2012 getting Access Database Corruption

Cannot access shared files or folders on a drive in Windows Server 2012 or Windows Server 2012 R2

Comments:

It’s a bit strange though as the patch to fix the issue is back in May 2014 which is already installed on the server.

I can only think that something in the latest Windows 10 Build 1803 has brought up the issue again as it was PC’s that are running that build were causing the problem.

The fix is adding the following entry into Vospers Server 2012 R2 registry:

Key:   HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServiceslanmanserverparameters
Value: DisableLeasing
Type:  DWORD
Data:  0x1

We testing this on our server and the problem went away. As soon as we changed the ‘Disable leasing’ value to ‘0’ again, the problem returned.

I can’t find a reasonable explanation yet as to why this has started to happen last week but if it works and doesn’t cause any further issues elsewhere then I’m ok with that.