[AccessD] Locking question

Gary Kjos garykjos at gmail.com
Wed Jul 27 13:44:50 CDT 2005


Hi Bobby,

The users need to have File Creation rights in the folder that the BE
database lives in so the LDB file can be created. Is there an LDB file
being created for the BE when the first user is in there? I think with
one user it will allow access without being able to create the LDB
file but will lock out the second user? I could be out in left field
wandering in my own dream world too of course. I do know that users of
our Access databases need full file creation, change and deletion
rights in the folder or else it doesn't work.

On 7/27/05, Bobby Heid <bheid at appdevgrp.com> wrote:
> Hey,
> 
> Our clients use our system on a network where each user has a FE against the
> BE on the server.  While the app was originally written to all be on the
> local pc, it has migrated to the server.  Usually all goes well.
> 
> Well, this one client has some weird happenings going on.  One user will be
> in the database in any given form.  Another user cannot get access to the BE
> until the 1st user exits the form they were in.  The first thing the app
> does is to relink the tables to the last BE that was loaded.  It sounds like
> there are some sort of issues with locking and the LDB file.
> 
> Anyone have any pointers?
> 
> Thanks,
> Bobby
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


-- 
Gary Kjos
garykjos at gmail.com



More information about the AccessD mailing list