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