Current user list

[gsc_81]

Does anyone know of a program to discern current users while a db is in need of repair? We are on Citrix server so even if I could view the lock file it would just show the server and Admin as user name.
I inherited a db that needs repair multiple times weekly, finding out who is still connected quickly is essential. Anyone have any ideas?

thanks.

 

[ghudson]

Not possible since they all log into the Citrix server.

You will have to track their network name or computer name. Store it in a linked table [the db is split?] and remove their info when the correctly exit the db.

The Environ() function is the easiest way to grab their network name and computer name. Try this for a quick test...

MsgBox Environ("UserName")
MsgBox Environ("ComputerName")