SandySun said:
Does anyone know how to go about tracking who's in the database (user,
date,
time) and when they exited the database. Thanks!
http://www.mvps.org/access/modules/mdl0055.htm -- on viewing the .LDB
http://www.mvps.org/access/general/gen0034.htm -- who's logged in, also uses
..LDB
Both require you have implemented Access security. You can't do that with an
Access 2007 ACCDB, because the user/group level security is not supported.
If you are presenting users with a fully-developed application, and that's
the only way they can get in, then you can include startup code to keep
track of who's in and out, and you can have an invisible form in the
background which has a Close event that records their leaving. And, you can
use the method in
http://www.mvps.org/access/api/api0008.htm to retrieve
their Windows logon, and thus don't have to rely on having properly
implemented Access security. You do need to exercise a certain amount of
care to lock-down the application so the users can't log in directly to the
database outside your application.
Larry Linson
Microsoft Office Access MVP
