User List

[rlatini]

I am trying to maintain a list of connected users to a database. Now I'm wondering if there's anything built into Access 2000 with security and so on where an admin user can check the list of connected users. I've thought about just doing it manually, adding to a table upon login and removing upon closing the application. The problem with that is if Access freezes, then it won't go through the normal process. So, is there an easy way of doing that or any other work arounds anyone might know.

 

[mdmilner]

No, there isn't a built in way to do it but there is a way by looking at the *.ldb file (Access Lock File) which maintains an active record of all connected users continuously.

Take a look at this application example.

http://www.fabalou.com/FullPrograms/Dblauncher.asp

Mike