Asger Blond
ab-mi at post3.tele.dk
Wed Jan 19 13:41:00 CST 2011
Thanks to all who replied! I asked the question on behalf of a colleague (who is not on this list) and I don't have contact to the customer in question. But I'm told that the version of Access is 2003 and all users have full rights on folder hosting the BE on the Synology-NAS server. I'll hand over your responses to my colleague - maybe it will give him some clues. Thanks again for the answers Asger -----Oprindelig meddelelse----- Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Jim Dettman Sendt: 19. januar 2011 19:18 Til: 'Access Developers discussion and problem solving' Emne: Re: [AccessD] Multi-user Access db on NAS 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com