Forum Discussion

PeteHadden's avatar
PeteHadden
Copper Contributor
Dec 15, 2021
Solved

Database no longer shareable

For years we've used a split front-end / back-end Access DB. Each PC has a copy of the client and the backend data lives on a NAS drive. For some reason recently, once one user opens their client, no...
Access Lock Share laccdb
caseyg1760's avatar
caseyg1760
Copper Contributor
Dec 22, 2021

cv_Frank - We are on the exact 64 bit build and the issue is persistent on our end. Fix it MS! I may be rolling back tomorrow morning. 

Karl_Donaubauer's avatar
Karl_Donaubauer
MVP
Dec 22, 2021

Hi,

Today Microsoft has updated the bug article with this caveat:

 

Note: If you are using Distributed File System Namespaces (DFS Namespaces overview | Microsoft Docs) to redirect a folder that contains an Access database, you will still see the issue that you cannot open the database for shared use, even with the fixed update.
You should use the direct path to the database to allow shared usage.

 

Servus

Karl

Access News

  • caseyg1760's avatar
    caseyg1760
    Copper Contributor
    Dec 22, 2021
    We use dfsr but not dfsn so I don't know if this applies to us or not. We just map all our drives via GPO. So it's just UNC path to the servers/shares.
    • GustavBrock's avatar
      GustavBrock
      MVP
      Dec 23, 2021

      caseyg1760 

      It doesn't matter wether you use an UNC path or a mapped drive. What matters is, if the UNC path used (for the mapped drive) is a virtual DFS path. If so, change the path used from the DFS path to a path having one of the member servers of the DFS name space.

       

      If you prefer to roll back to a previous version not hit by this issue, I've found it to be this (or earlier):

       

      Version 2102 (Build 13801.21050 Click and run) semi-annual enterprise

      • ShakerDB's avatar
        ShakerDB
        Copper Contributor
        Dec 23, 2021

        GustavBrock 

        As I'm not familiar with the server structure and all this terminology, I won't update office for the time being until this bug is completely gone. It safer that way (at least for myself).

        Happy holidays guys and thank you for all your help.

  • caseyg1760's avatar
    caseyg1760
    Copper Contributor
    Dec 22, 2021
    Hi Karl, so don't use the share name but the full 'UNC' path?

    Thanks
    Casey

Resources