Who's In The Database?

[egun]

Hi,

I'm wondering if there is an easy way to display the usernames of all people
accessing a database at the same time. I would rather avoid having users log
in to the database. They are already given access to the server on which the
database resides, and that's enough. All I would like to do is to display a
list of current users (i.e. those who have the database file open).

Any suggestions are appreciated.

Eric

 

[egun]

Thanks, I'll give that a try. Looks like a possible way to create a simple
audit trail, too.

 

[Ron2006]

Beaware that if a person aborts out of Access or there is a power
outage - that type of thing, then the table will be incorrect untill
then exit normally again.

If you are just trying to see who is on, the following may be usefull.

Try this link: http://www.mvps.org/access/modules/mdl0055.htm

it has a small access app that looks at the ldb file and will tell you
all of the users that are logged into mdb that you reference.


really neat and small, and the code for the form can be imported into
any app that you want or run standalone out of this app. With that you
may be able to tell what machine is actually holding open the ldb file
without having to try to guess.


Ron

 

[punjab_tom]

exec sp_who2

SQL Server has a lot of functionality like this that is built into the
db.

MDB isn't suitable for a single user and a single record

-Tom