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
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.

Resources