database users (list of)

[Crystal]

I've found several articles and code samples for listing
users currently logged into a database via the ldb file.
Unfortunately, this file doesn't seem to update when a
user logs off.

I tried cheating and creating code that added the machine
name to a table when the database opened, but this has too
many holes in it.

Is there another way to harvest : Machine Name, User Name,
Connected (Yes/No), and SuspectState(Yes/No) for a
database *not* using the ldb?

Any suggestions would be greatly appreciated,
Crystal

 

[Bish]

I have emailed a utility database that has a single form.
The form does read the ldb file but does work. You can
port the form to your database and it should work....