View who is logged on

K

Kevin

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
 
D

Douglas J. Steele

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top