Access / how many users connected?

If it is network connections (not terminal) you can use operating system (Computer management), which will show you who is connected to shared files.

in the folder where data.mdb is located, locate for the file  data.ldb
you can open this with word and you will see the computer and user that is connecting to the data.mdb

see this link too

How to determine who is logged on to a database by using Microsoft Jet UserRoster in Access
http://support.microsoft.com/?kbid=285822

You can use the MS LDB Viewer: (free)

http://support.microsoft.com/default.aspx?scid=kb;EN-US;176670

Download the Jetutils.exe file, which includes the LDB Viewer.  Easy to install.

mx

Here is another version (the Lite version free) that supports A2007/10:

http://www.akcesoft.com/html/accuserlist.html

mx

There's also the  MSDBUSR.DLL for A95 and up if you want to stick with DAO and not use ADO.
JimD.

capricorn1:
Yes, that is that I am looking for.
However if one opens the mdb twice from the same pc it shows it only as once.
Is there away to show both or to prevent the mdb from opening again from same pc?

:Is there away to show both or to prevent the mdb from opening again from same pc?:

Either of the links I posted will do this ... show both.

mx

Jess31,

see the codes from this link

http://www.mvps.org/access/api/api0041.htm

From the link I see that
>The simplest way to ensure that only one instance of the database can be opened on one desktop is to open the mdb file exclusively.
And since it is the front end mdb that is on a users desk that I want to prevent opening a second time this would seem the most direct way of doing it. Is this right?
How can I make it so that it opens in Exclusive mode?

DatabaseMX:
Thanks for the links.
The links you posted seem to be external programs that will give this information. But I need this from inside an access application. I also don't want to have to have another program to get this information since if it gets erased by somoneone that becomes a problem.

"But I need this from inside an access application."
That really wasn't mentioned in the Q.

"And since it is the front end mdb that is on a users desk that I want to prevent opening a second time this "
How would that happen anyway ?

mx

>How would that happen

Are you asking how would it happen that someone will open the same problem twice? Or how could it be prvented?

the "And since it is the front end mdb that is on a users desk that I want to prevent opening a second time this" is referring only to the part that I would like to keep the front end from being opened twice on the same PC, not to the orriginal question about how many people are connected to the back-end.

I'm asking for a give PC, how would someone actually open the same MDB twice ?

mx

open access and open hte db

"Yes, but to open exclusively is a pain (IMHO) because it is most often done through the target property of a shortcut. "

In fact ... >>  http://support.microsoft.com/kb/304528

mx