Get All User ids logged into the database

  • Thread starter Thread starter John F. via AccessMonster.com
  • Start date Start date
J

John F. via AccessMonster.com

I'm using =FOSUserName() on my form which gives me the userid that made the
update to the form. But this is just one userid.

Is there a way that I use this or something else to get a list of ALL the
userids that are logged into the database?

Thanks,
John
 
I don't think there's going to be a very elegant way of doing this. You
could look at the ldb file, but that will just give you the Access usernames
of the logged in users (so normally just various people called admin unless
you have security enabled).

The straightforward method would be to append usernames to a table when
people enter the db, and delete when they're on their way out. This will go
wrong if people cause application errors and crash out, but as long as your
code and/or error handling is working, then it should work.
 
There's really no way to do that in Access.

If you've applied User-Level Security, so that each user has to log into
Access, their Access ID (as opposed to their Windows ID) will be stored in
the LDB file, but there's no way to get their Windows ID.
 
Back
Top