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

Jeroen 0 Reputation points
2024-07-16T12:36:57.1266667+00:00

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

Azure Disk Storage
Azure Disk Storage
A high-performance, durable block storage designed to be used with Azure Virtual Machines and Azure VMware Solution.
617 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. KarishmaTiwari-MSFT 19,692 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://video2.skills-academy.com/en-us/troubleshoot/azure/azure-storage/files/connectivity/files-troubleshoot-smb-connectivity?tabs=windows

    https://video2.skills-academy.com/en-us/troubleshoot/azure/azure-storage/files/performance/files-troubleshoot-performance?tabs=windows

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.