Login Tracker for Access

[Tboartz]

Is anyone aware of some sort of program or coding that would allow the Admin
of hte database the ability to see who exactly is logged into the database at
any particular time?

Any help would be appreciated,
Tboartz

 

[Douglas J. Steele]

Take a look at http://support.microsoft.com/kb/198755 but also be aware of
the caveats in http://support.microsoft.com/kb/208778 (especially "When a
user closes a shared database, the user's entry is not removed from the .ldb
file. However, it may be overwritten when another user opens the database.
This means that you cannot use the .ldb file alone to determine who is
currently using the database. ")

Note, too, that unless you've applied Access User-Level Security (Access
2003 or older), all you're going to see as the "Security name" is "Admin"
for all users.

You might also take a look at Total Access Admin, from FMS
http://www.fmsinc.com/MicrosoftAccess/monitor.asp

 

[Tboartz]

Thank you, this is exactly what i needed to research =)

Terri