>Another approach to this is to use an active flag in your users table. So, instead of checking the lock, when a user logs out or in you toggle the flag. Why? Because you might have some cases where user's can log in more than once.
>
>>I have a login screen in my vfp app that tests for a record lock before allowing users to login. If this lock fails, it
>...snip

I do have a logical field that is populated when a user logs in, however, when the application is not exited normally (Crash etc.) the user is still flagged as being logged on. That is why I used the locking technique. In this particular app I cannot allow concurrent logins. The locking works fine now as I was using the isrlocked() function when I should have been using rlock().

Thanks for your help!

john.