Home  |   French  |   About  |   Search  | mvps.org  

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

In Memoriam

Terms of Use


VB Petition

Modules: LDB Viewer Form

Author(s)
Dev Ashish
 

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 KB Article Q176670 and at SysInternals website. [ 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 and UserRoster]
    • 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.

Download:

  AppUser.zip (Access 2000, 67,445 bytes)
  See Screenshot (1)
See Screenshot (2)

Usage Information:

Use the database as a standalone admin utility, or import the form in your own Access 2000 database.

Credits:

bullet Kevin Collins (MSFT) and Bob Delavan (MSFT) for msldbusr.dll
bullet Michael Kaplan (Trigeminal) for ldbviewer sample
bullet Mark Russinovich (SysInternals) for it's LoggedOn console app
 
 
Access 2000 and Access 2002:
 
        Access 2000 - KB Article 198755
        Access 2002 - KB Article 285822
 
 

Contact Information:

Please contact Dev Ashish for any additional questions.

 


1998-2010, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer