By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,969 Members | 2,422 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,969 IT Pros & Developers. It's quick & easy.

Who has locked the mdb

P: n/a
We have an mdb for about 5 users. They don't have to log in to get into the
mdb, they just open it. However, sometimes we need to make sure no one is in
the mdb. From the ldb we then see that some one is in the database. Is there
some way to find out which user in still in the mdb?
Thanks,
john
Apr 30 '07 #1
Share this Question
Share on Google+
6 Replies


P: n/a
John wrote:
We have an mdb for about 5 users. They don't have to log in to get into the
mdb, they just open it. However, sometimes we need to make sure no one is in
the mdb. From the ldb we then see that some one is in the database. Is there
some way to find out which user in still in the mdb?
Thanks,
john

Well, I believe it depends on the version of Access. I think A97 used
LDBView. After 97, see if
http://support.microsoft.com/default...b;en-us;285822 works.

You might also want to look for msldbusr.dll in google groups

Apr 30 '07 #2

P: n/a

"salad" <oi*@vinegar.comwrote in message
news:Xu*****************@newsread1.news.pas.earthl ink.net...
John wrote:
We have an mdb for about 5 users. They don't have to log in to get into
the
mdb, they just open it. However, sometimes we need to make sure no one
is in
the mdb. From the ldb we then see that some one is in the database. Is
there
some way to find out which user in still in the mdb?
Thanks,
john
Well, I believe it depends on the version of Access. I think A97 used
LDBView. After 97, see if
http://support.microsoft.com/default...b;en-us;285822 works.

You might also want to look for msldbusr.dll in google groups
If Access security is not being used, all users will be listed as Admin. You
can used Windows file share utilities to show which computers have the file
open.

Why do you need to make sure no one is in the mdb? Are the 5 users opening
the same front end. If so, split the database into a front end, back end,
giving each user a copy of the front end. This should eliminate the need
kick all other users out of the database.
Apr 30 '07 #3

P: n/a
"paii, Ron" <pa**@packairinc.comschreef in bericht
news:7N******************************@athenet.net. ..
>
"salad" <oi*@vinegar.comwrote in message
news:Xu*****************@newsread1.news.pas.earthl ink.net...
>John wrote:
We have an mdb for about 5 users. They don't have to log in to get into
the
mdb, they just open it. However, sometimes we need to make sure no one
is in
the mdb. From the ldb we then see that some one is in the database. Is
there
some way to find out which user in still in the mdb?
Thanks,
john

Well, I believe it depends on the version of Access. I think A97 used
LDBView. After 97, see if
http://support.microsoft.com/default...b;en-us;285822 works.

You might also want to look for msldbusr.dll in google groups

If Access security is not being used, all users will be listed as Admin.
You
can used Windows file share utilities to show which computers have the
file
open.

Why do you need to make sure no one is in the mdb? Are the 5 users opening
the same front end. If so, split the database into a front end, back end,
giving each user a copy of the front end. This should eliminate the need
kick all other users out of the database.
In this case we had to make sure on one was in the mdb because of several
global replace en delete actions. These actions were made on a copy of the
database (after people exited the mdb). We had to make sure no one would
edit records in the mean time.

Thanks to you both...
john
Apr 30 '07 #4

P: n/a
paii, Ron wrote:
"salad" <oi*@vinegar.comwrote in message
news:Xu*****************@newsread1.news.pas.earthl ink.net...
>>John wrote:
>>>We have an mdb for about 5 users. They don't have to log in to get into

the
>>>mdb, they just open it. However, sometimes we need to make sure no one

is in
>>>the mdb. From the ldb we then see that some one is in the database. Is

there
>>>some way to find out which user in still in the mdb?
Thanks,
john


Well, I believe it depends on the version of Access. I think A97 used
LDBView. After 97, see if
http://support.microsoft.com/default...b;en-us;285822 works.

You might also want to look for msldbusr.dll in google groups


If Access security is not being used, all users will be listed as Admin. You
can used Windows file share utilities to show which computers have the file
open.
That may be true with some alternatives but in A97 using MSLDBUSR.DLL
the results returned is the computer name not the user name. Which
works out A-OK if the computer name is significant in identifying the
location.
Why do you need to make sure no one is in the mdb? Are the 5 users opening
the same front end. If so, split the database into a front end, back end,
giving each user a copy of the front end. This should eliminate the need
kick all other users out of the database.
May 1 '07 #5

P: n/a
salad <oi*@vinegar.comwrote in
news:Xu*****************@newsread1.news.pas.earthl ink.net:
John wrote:
>We have an mdb for about 5 users. They don't have to log in to
get into the mdb, they just open it. However, sometimes we need
to make sure no one is in the mdb. From the ldb we then see that
some one is in the database. Is there some way to find out which
user in still in the mdb?
Well, I believe it depends on the version of Access. I think A97
used LDBView. After 97, see if
http://support.microsoft.com/default...b;en-us;285822
works.

You might also want to look for msldbusr.dll in google groups
I recently posted a sample database that does this:

htto://dfenton.com/DFA/download/Access/WhosOnADO.zip

This uses ADO UserRoster and works for Jet 4 and Jet 3.5 (though not
all the options work for Jet 3.5 -- it does tell you who is logged
on).

A different version of the same thing is in my simple Admin utility.
It includes both the ADO UserRoster method and the DLL-based
version. The DLL is in the zip file:

htto://dfenton.com/DFA/download/Access/Admin.zip

Strangely enough, the DLL approach seems to work wtih both Jet 3.5
and Jet 4.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
May 1 '07 #6

P: n/a
"paii, Ron" <pa**@packairinc.comwrote in
news:7N******************************@athenet.net:
If Access security is not being used, all users will be listed as
Admin. You can used Windows file share utilities to show which
computers have the file open.
Using what method? Both ADO UserRoster and the msldbusr.dll give you
both the Jet ULS username and the workstation name.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
May 1 '07 #7

This discussion thread is closed

Replies have been disabled for this discussion.