Multi User Lockout

Albert,
Enlighten me if I am confused. His user is using a different FE, hopefully
on his own computer. Since he is opening the FE, wouldn't his .ldb files and
others be there?

"Albert D.Kallal" wrote:

Upon closing my .mdb, his FE can open
normally. I can then reopen my FE and it seems to be working correctly. So,
I
am not sure why it doesn't seem to be letting multiple users in.

You need to check and ensure that your users to the shared folder have FULL
rights. When I say full rights, we are talking about file create rights,
file delete rights etc. When ms-access starts, it needs to create some
locking files to allow it so run in multi user mode. What happens when some
users don't have full rights to the folder, then ms-access can't create
these temp files to manage collisions, and there for opens the file in
SINGLE USER mode.

In addition to the above, it is possible that the settings (in your mde, or
mdb) file were set to open the file exclusive, and again this means that the
users settings will be for single user mode. Check out the settings in

tools-options-advanced tab.

Take a look at the above settings, and make sure the default open is set to
shared.

And, also check out the permissions you gave to users to the shared folder
where the mdb is, since temp files need to be created, and deleted in this
folder. (in fact, the persistent connection trick fixes performance problems
due to those temp files not having to be created, and deleted).


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.members.shaw.ca/AlbertKallal

Klatuu wrote:
Albert,
Enlighten me if I am confused. His user is using a different FE,
hopefully on his own computer. Since he is opening the FE, wouldn't
his .ldb files and others be there?

In a split app two LDB files are created. One for the front end and one for
the back end. Each is created in the same folder as the corresponding app
file.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

The FE is installed on each user's computer. Does the BE generate a separate
lockfile for each user, or does it keep track of multiple users within a
single file?

Matt Martin


"Rick Brandt" wrote:

Klatuu wrote:
Albert,
Enlighten me if I am confused. His user is using a different FE,
hopefully on his own computer. Since he is opening the FE, wouldn't
his .ldb files and others be there?

In a split app two LDB files are created. One for the front end and one for
the back end. Each is created in the same folder as the corresponding app
file.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

"Klatuu" wrote in message
...
Albert,
Enlighten me if I am confused. His user is using a different FE, hopefully
on his own computer. Since he is opening the FE, wouldn't his .ldb files
and
others be there?

Temp locking files are created on the shared folder. Ask your self how does
ms-access handle collisions between multiple users when no software runs on
the server side? (answer: Each front end creates entries in a locking file
that is in the shared folder, and thus each front end can look at this
shared file and manage the collisions).

Sure, a locking file is also created in the front end folder, but that would
be used only for local tables in the FE.

So, if locking files can't be deleted, and created in the back end folder,
then ms-access can't run in multi-user mode. It needs these files so each
front end can figure out who what got what record locked.

Ms-access has to manage and figure out how to deal with multi-users, and
that information can't possibly be in the front end folder...so, naturally,
that locking information is SHARED amount all of the front ends...just like
the data file is......


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.members.shaw.ca/AlbertKallal

"MartinMCU" wrote in message
...
The FE is installed on each user's computer. Does the BE generate a
separate
lockfile for each user, or does it keep track of multiple users within a
single file?

There is ONE lock file created on the server that ALL of the fronts use. So,
only ONE lock file is made, and the first user in creates this lock file.

The above explains often why people ask how come when certain users go in
first, that NO other users can work. Where as if other users go in first,
then all others can work. (answer: that first user going in has
create/delete rights to the folder...where the other user did not. As
mentioned, if ms-access can't create the locking file in the BE to be shared
by ALL users, then multi-user operation cannot happen).

This shared folder is where information about collisions and record locking
occurs. Very simply if ms-access can't make that file, then it can't manage
multiple users.


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.members.shaw.ca/AlbertKallal