[AccessD] Multi-user Access db on NAS

Jim Dettman jimdettman at verizon.net
Wed Jan 19 12:17:31 CST 2011


Asger,

<<Some googling seems to indicate that the operating system on the NAS
doesn't support the file locking mechanism (I guess for the ldb file) that
Access needs for multi-user usage and that the db has to be placed on a
Windows machine.>>

  I suppose that's possible, JET/ACE use extended byte range locking on the
.LDB file to hold locks for the DB.  What that means is it places locks on
portions of the .LDB file that don't exist.  In that way, the DB file never
has a lock directly placed on it and they can use what ever kind of locking
scheme they want.

  If that really is the case, then there is no work around.  JET/ACE will
open a db in exclusive mode if it can't place locks.

  But as the others have said, check the basics; make sure everyone has full
security for the directory where the DB resides and that the DB's are not
getting virus scanned.  Also, make sure that you don't have different DB
types in the same directory with the same base name. ie.  myApp.MDW and
myApp.MDB.

  Both will end up with the same .LDB file name myApp.LDB, and all kinds of
weird things will happen after that.

  It's kind of odd that it just hangs without coming back and saying it's
opened exclusive already.  You might have something else going on.

Jim.
  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Asger Blond
Sent: Wednesday, January 19, 2011 11:15 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Multi-user Access db on NAS

One of my colleagues has set up a NAS server for a customer who is now
complaining that the Access BE hosted on the NAS doesn't allow multi-user
access. The db can be accessed ok from each site separately, but when opened
by another user the db doesn't respond (no error message, just nothing
happening when trying to open).

Some googling seems to indicate that the operating system on the NAS doesn't
support the file locking mechanism (I guess for the ldb file) that Access
needs for multi-user usage and that the db has to be placed on a Windows
machine.

Do any of you have experience with this? Any workaround?

Asger


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list