View who is logged on

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

I would like to be able to view who is logged on to the DB, and also to view
log on history.

Is this possible?

Kev
 
Access doesn't keep log on history. If you want to have such information,
you'd have to write to a table each time a user opens the database. If you
also write as they're closing the database, you'd then be able to get who's
currently logged on from that table.

To get who's currently logged on, check out
http://support.microsoft.com/?id=285822 (I believe that technique also works
with Access 2000. For Access 97, check
http://support.microsoft.com/?id=186304)

Note that all Access will be able to tell you is the Access User
information. If you've applied User-Level Security, that will be the id the
user logs into the application with. If you haven't applied ULS, all users
will show as "admin" (their Computer Name will be correct, however)
 
Back
Top