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)
 

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

Similar Threads

Is It Just Me? 8
Who's in the database? 2
Logging User Access 3
Who's Online? 5
Logging Login 1
User log in issues 2
Excel Log Log Graph on Excel 0
Firefox Multi-Account Containers 1

Back
Top