Hi!

I asked this question a while ago and got some good advise...

My strategy was to...
Create a folder on the server containing a seperate folder for each user.
Example:
Profiles
-User1
foxuser.dbf
foxuser.fpt
-User2
foxuser.dbf
foxuser.fpt

When a user logs in they get their own personal foxuser.dbf file..
Via SET RESOURCE TO....

When they log out or the program crashes..
Their foxuser file is automatically deleted

The only trick was that NT seems to do something funny with the files:
And locks the ftp file longer then would be expexted

SO:
I use the open files function by Paul Vlad Tatavu
See FAQ#7896
And check how which FOXUSER.DBF's are locked and then from the folder name I have the user
that is in the system.

Note: do not check the ftp file becuase it doesn't always give the right results...

If using a client server application:
For example Oracle it's very simple:
SQLEXEC(h,"Select * from v$session","usersin")

Note: I also use this to see how many concurrent users are in the application...