[AccessD] Multi-user Access db on NAS

Boyd Trimmell accesscoach at hitechcoach.com
Wed Jan 19 10:39:29 CST 2011


What version of Access?

Is the database split with each user having their own (not shared) copy of the front end?  This really is a must for multi user database. 


Boyd Trimmell 
aka HiTechCoach at UtterAccess.com and other support sites
Microsoft Access MVP 2010 ( MVP Profile )


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Asger Blond
Sent: Wednesday, January 19, 2011 10: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