473,320 Members | 1,732 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Who has locked the mdb

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

"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
"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
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
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
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Tech | last post by:
In Visual Basic 6.0, the Locked property of a ComboBox control determined whether the text-box portion of the control could be edited. In Visual Basic ..NET, the Locked property prevents a control...
6
by: DebbieG | last post by:
I have created a database for a client and was told that it was to be a one-user database. Well, you know the next statement ... now they want 3 people to be able to use the database. (FYI, I...
2
by: Ken Durden | last post by:
I'm setting up an interface where clients must perform external locking before calling certain commands. I do this to force them to specify the duration the action they performed must persist...
7
by: Andrea Moro | last post by:
I'm writing my first windows control library. A simple textbox with some numeric facilities. Well, there is a strange thing that happen. I want to add a locked property. As many other property,...
6
by: elake | last post by:
I found this thread about a pst file in Windows being locked and I am having the same issue. ...
8
by: kevin.vaughan | last post by:
Good Afternoon Everyone, Could someone please explain why I can't set the Subform control Visible attribute to False as below? The statement for the locked attributes work but not for the...
6
by: ljstern | last post by:
Hello. I am using MS Access 2003 with XP/pro. I have a form that has the following properties set through the property sheet: form: AllowAdditions = False CartridgeID field: Locked = True ...
1
by: Damjan Malis | last post by:
Hi guys... could anyone please help me with my problem getting mouse cursor position while desktop being locked (WIN + L). MSDN says: "The input desktop must be the current desktop when you...
2
by: Josh Burkard | last post by:
Hello For a alarm-system in our company i want to show a message-window at the users screen while some events, even the users computer (Win XP SP 2 in domain) is locked. How can i show a...
18
by: =?Utf-8?B?VGhlU2lsdmVySGFtbWVy?= | last post by:
Because C# has no native SSH class, I am using SharpSSH. Sometimes, for reasons I do not know, a Connect call will totally lock up the thread and never return. I am sure it has something to do...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.