Microsoft Access DBEngine.OpenDatabase() breaks for Network-Paths (after KB 5008212) - Error 3050

Question

We have an Access Database-Solution with Frontend and Backend Database running for years.

Now within the last two days problems occurred. E.g.

Set db = DBEngine.OpenDatabase(strDatabasePath, False, True, "MS Access;PWD=" & strPassword)

Does result in Error 3050 - File could not be locked. ONLY when the Backend Database is on a network share (if it's on a local drive everything works as expected).

The error occurs on any share:

• a Shared Folder from a Windows PC
• a Shared (Samba) Folder on a NAS
• independently whether the share is accessed via

a UNC-Path (\server\share) or a mapped drive-path.

The error does only occur after KB 5008212 (no clients without that update had the problem). Unfortunately after removing KB 5008212 the problem persists.

Has anybody noticed the same problem or even better a working solution?

Thanks for your help!

Answer 1

Seems like Microsoft got it wrong - see https://stackoverflow.com/questions/70365001/microsoft-access-dbengine-opendatabase-breaks-for-network-paths-after-kb-5008

I reverted to Version 16.0.14527.20234 and it worked again.