[AccessD] Multi-user Access db on NAS

Hi Asger:

Unless the directory where the Access BE resides allows full read, write,
create and delete access it isn't going to work...also there are timing
issues (Real-time security can not/should not be run on a server...that in
particular screws up Access). I am having similar problems with a client's
SBS. It may be the way the systems IT set it up or maybe it is just the way
new servers are designed.

I believe that the Access MDB BE is dead as a database on the new systems.
Migrate to a real SQL server BE and your problems will just disappear.

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 8: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