NSS6100 & FILE LOCKING ISSUES ! [ Edited ]

[codecks]

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

Message Edited by codecks on 11-19-2007 06:28 AM

[BostonGuy]

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.

[codecks]

Can anyone think of a workaround for this issue ? I was thinking of migrating the db to mysql, but this is a lot of work. Is there no possible way of tweaking the linksys nss6100 ?

[cubmanky]

I'm in the same boat.  Looking for a fix to

[codecks]

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.

As for samba file locking you can check this page : http://www.samba.org/samba/docs/man/Samba-HOWTO-Collection/locking.html (in particular : Multiuser database and MS Windows Oplocks and Caching Controls) As you can understand opportunistic lock is disabled on the device. The NSS priority is to avoid any possible file 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.)

Message Edited by Vince_02 on 11-19-2007 07:44 AM

[cubmanky]

I find it interesting on how just the basic things one would do on and use a file server for are the ones the linksys will not allow. 

[codecks]

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