User list

[Steve S]

I have a database on a server that houses a number of departmental tables
linked to separate applications on different users desktops. Is there a way
for me to tell who is logged into the database on the server?
Thanks in advance,

 

[mscertified]

One way is to set up a table for userids. When anyone logs in, add their
userid to the table, when they log out, remove their name from the table.
This requires that you prevent users exiting except via a single exit
button, i.e. you have to disable the close command.

-Dorian

 

[OldPro]

I have a database on a server that houses a number of departmental tables
linked to separate applications on different users desktops. Is there a way
for me to tell who is logged into the database on the server?
Thanks in advance,

Access creates a file with the same name as your database and an
extension of ".ldb" when there are two or more people using the same
database. You might be able to glean some information from it.

 

[Pieter Wijnen]

<correction> the ldb is created/modified if the db is not opened in exlusive
mode </correction>

Pieter