INFORMATION PROVIDED IN THIS DOCUMENT AND THE LDB VIEWER FORM IS PROVIDED
"AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED. THE
USER ASSUMES THE ENTIRE RISK OF RUNNING THIS SOFTWARE.
© 2000-2002, Dev Ashish
The LDB Viewer is an Access 2000 form that displays information about the
users currently connected to the database. It uses sample code and
techniques described in the
Article Q176670 and at SysInternals
[ Also see Get full name of the user currently logged in to the system, General:
Who's logged in?]
The form uses the APIs exposed by msldbusr.dll, and optionally, Jet
4.0's UserRoster for a Jet 4 database, to display the following pieces
of information about the users currently connected to the database:
- Machine Name [ msldbusr.dll and UserRoster ]
- User currently logged in (NT UserID) [ msldbusr
- Login Name [ Jet 4 UserRoster Only ]
- Connected Flag [ Jet 4 UserRoster Only ]
- Suspect State Flag [ Jet 4 UserRoster Only]
For the NT UserID, Windows NT or Windows
2000 is a requirement.
Use the database as a standalone admin utility, or import the form in
your own Access 2000 database.