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
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.
- 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.
- 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
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
In Access 2000, you can use Jet's UserRoster, a
provider-specific schema rowset in the Jet 4 OLE DB provider.