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

papa_bear 1 Reputation point
2021-12-15T14:29:59.89+00:00

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!

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
797 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. papa_bear 1 Reputation point
    2021-12-15T19:21:19.14+00:00

    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.