[AccessD] Locking question

Jim Dettman jimdettman at earthlink.net
Sat Jul 30 10:43:32 CDT 2005


Gary,

  No, you hit it right on the head.  If Access cannot create a LDB file, it
opens the MDB/MDE in exclusive mode.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gary Kjos
Sent: Wednesday, July 27, 2005 2:45 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Locking question


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