Home  |  About  |   Search   

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

RunCommand Constants

Terms of Use


 

General: Who's logged in?

Author(s)
Dev Ashish

Note:

This article assumes that you have properly implemented Access security in your application (which is split into a backend/frontend).  For steps and other tips, read the Security FAQ.

In Access 97 and earlier versions, there's no built-in way to get a list of all users currently using your application.  

Also see Modules: LDB Viewer Form.

    You can

  1. maintain a table where the value of  CurrentUser function is appended with a date/time stamp from the startup code.  When the user exits the application, this record will get deleted.  
    To handle situations where the user may leave the application open indefinitely, you need to build in automated logout routines. 
  1. read the list of users from the associated LDB file.
   ACG Soft's website

Download Mark Nally's samples from the Files section. These sample mdbs demonstrate code to get a list of Access users and machine names for Users currently logged on to an Access database in a multiuser environment 
   176670
ACC: Microsoft Jet Utilities Available on MSL


The Jetutils.exe file contains the "Understanding Microsoft Jet Locking" white paper, the LDBView utility, the DBLock utility, and the Msldbusr.dll.  The Msldbusr.dll is a 32-bit DLL that enables you to retrieve one of the most sought-after pieces of information: a list of users connected to the database. Because this is a 32-bit DLL, it will only work with 32-bit products running on Windows 95 or Windows NT. It retrieves information for both Microsoft Jet 2.x and Microsoft Jet 3.x databases.

In Access 2000, you can use Jet's UserRoster, a provider-specific schema rowset in the Jet 4 OLE DB provider.

   198755
ACC2000: Checking Who Logged into Database with Jet UserRoster

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