We're just upgrading to Access 2000 under a thin-client
(Citrix) environment.

We have previously been able to determine which users are
locking Access databases by using the Msldbusr.dll from
Microsoft and a customised version of the LDBView.exe
program.

Using the API provided in the DLL, we were able to
retrieve ID's of the machines connected to the database

Declare Function LDBUser_GetUsers Lib "MSLDBUSR.DLL" _
(lpszUserBuffer() As String, ByVal lpszFilename As String,
ByVal nOptions As Long) As Integer

The array returned in lpszUserBuffer listed all machine
IDs, rather than user logins, which under fat client was
no problem. Match the machine name to the user & you know
who is connected.

However, under Citrix, the array simply returns the server
names connected to the database. So, we have multiple
users accessing a database via CITRIX01, but CITRIX01 is
all that is displayed as the locking user.

We are forcing all users to log in via a security
workgroup, so their name is being recorded in the LDB
file, but how are you supposed to retrieve the login name
using the APIs provided in MSLDBUSR.DLL??

I've thought about opening the .LDB for Input, then
parsing the string to extract machine & login names, but
this is problematic & a rather tedious solution when there
are APIs to do this...

Any suggestions to this problem appreciated.

Thanks