How to fix MS Access db cannot be opened by multiple users simultatiously

Jeroen 0

Hi,

I'm running into the following issue with azure file share:

Currenly hosting a MS Access db on a locally hosted networkdrive. This file can be accessed (read/write) by multiple users simultaniously.

When moving this database file to azure file share (mapped as networkdrive) it locks on the first user that opens the file and all the users which connect afterwards can't get access to the db file anymore until released by the first user.

I guess my questions are mainly:

Why is this?

Can this be fixed somehow, so multi user access works on azure file share?

Best,

Jeroen

KarishmaTiwari-MSFT 18,872 Reputation points Microsoft Employee

2024-07-17T03:06:30.0233333+00:00

@Jeroen

The behavior you described, where the database file locks for the first user and prevents subsequent users from accessing it, is likely due to file locking mechanisms.

When a user opens a file, it can acquire an exclusive lock (write lock) on the file. Other users trying to access the same file may be blocked until the lock is released. This behavior is common in file systems, including Azure file shares.

Azure file shares block unencrypted connections for security reasons. Ensure that you’re connecting from a client that supports SMB encryption (e.g., Windows 8/Windows Server 2012 or later). Connect from a virtual machine (VM) in the same datacenter as the Azure storage account to benefit from an encrypted communication channel. Verify that the “Secure transfer required” setting is disabled on the storage account if your client doesn’t support SMB encryption.

https://learn.microsoft.com/en-us/troubleshoot/azure/azure-storage/files/connectivity/files-troubleshoot-smb-connectivity?tabs=windows

https://learn.microsoft.com/en-us/troubleshoot/azure/azure-storage/files/performance/files-troubleshoot-performance?tabs=windows
Jeroen 0 Reputation points

2024-07-18T07:42:58.4933333+00:00

Thanks Karishma for your response. Seems the 'Secure transfer required' setting is locked by company policy. While I try and find my way to the right person who can help with this, I would like to check with you the following:

I can confirm all machines accessing the files are either win10 or win11, so then based on your initial response, this behaviour shouldn't happen as all users should be connecting using SMB encryption. Am I correct? If so, could there be something else still that can influence this behaviour?

Share via

How to fix MS Access db cannot be opened by multiple users simultatiously