Can I display users currently in an Access database?

  • Thread starter Thread starter Guest
  • Start date Start date
Yes. There are a couple of different things you can do:

1. Write code for Getting the User Roster. Resources:

http://support.microsoft.com/?id=198755

If it's Access 97, use LDBView:
http://support.microsoft.com/?id=176670
http://support.microsoft.com/?id=186304

2. Buy a product like Total Access Admin from FMS, Inc.
http://www.fmsinc.com/products/Admin/index.asp

--
Troy

Troy Munford
Development Operations Manager
FMS, Inc.
www.fmsinc.com


Is it possible to run a query or to list all users currently in a secured
database?
 
Thanks for your assistance, Troy.
Although I can't get it to work at present, I have run out of time and will
give it another good looking at tomorrow. Your post has given me a starting
point.
 
THANK YOU Troy!

It is amazing that this solution is not a part of the built-in help file
(i.e. installed with the Access files; searchable locally by the user rather
than going to internet); I suspect that a lot of shared database
users/admins are encountering this problem ... the admins don't know who is
(are) locking up the database, and therefore he/she can't make any changes!

Thanks again. -- LL in North Carolina.
 
Back
Top