Hello, Recently we switched our business data to a linksys nss 6100. The problem we are facing now is that we can't open a ms access db (stored on the nss) with more than one user (this was working before the switch). I suppose it has something to do with the permissions on the ldb file (access security/permission file). Once a second user tries to open the db, access says it can't lock the database. Does someone have an idea ? Thank you, Dimitri
I had the same issue with simultaneous access of some documents. I called Linksys a few weeks ago on this issue. They said there is a file locking issue with some files because they use a strict file locking implementation to prevent certain kinds of file corruption, since they support CIFS, NFS, and FTP on the same share folders. I believe it's due to this file locking mechanism that you're having a problem with your MS Access. I expect they should come out with a fix to relax this file locking, since others are having a problem with simultaneous file access.
11-19-200707:01 AM - last edited on 11-19-200707:44 AM by Vince_02
got an answer from linksys about the locking mechanisms present on the NSS devices.
"In the product sheet is mentioned that the device support UNIFIED FILE-LOCKING.
This mechanism is not ment to allow multiple concurrent connections but in the opposite is a system that prevents file corruption by rejecting multiple connections to the same file over different protocols.
For instance you are accessing a file using SMB and at the same time another use is accessing the same file over FTP, since both protocols are using different lock mechanism they will allow the two users to modify the same file at the same moment ... while with UNIFIED FILE-LOCKING the FTP will be notified that the file is already accessed through another protocol and will deny access to it to prevent corruption.
Seems not logic to me (read the two last lines). Tried the disable oplocks on the client side but had no success (see ms windows oplocks and caching control in the manual of samba). Anyone with refreshing ideas on how to solve this particular issue ?
(Mod note: Edited for guideline compliance. Thank you.)
I just got an answer from linksys. They now confirm that the nss was not designed to allow simultaneous access to files. For a device that allows 75 users... This should be a main feature and not a restriction!!