Boyd Trimmell
accesscoach at hitechcoach.com
Wed Jan 19 11:11:32 CST 2011
It is true that you must have read/write permission of the folder with the back end to be able to use the locking file. The Jet database (MDB) is definitely not dead. With Access 2007/2010 there is a new database engine called ACE that uses the .accdb format. Almost all my clients, including myself, use SBS and have no issues using it in a file server role with ACE or JET databases. 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 Jim Lawrence Sent: Wednesday, January 19, 2011 10:50 AM To: 'Access Developers discussion and problem solving' Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com