>>>>Is there any way to determine how many users are logged into a FoxPro app? I need for some processing to take place if a user is the last one to exit an app.
>>>
>>>You could have a table that a user write their login time to when entering the app and writes their logout time when exiting. Each time a user exits just check to see if their are any records with no logout times.
>>
>>This of course assumes the system never crashes, leaving a logged-in user.
>>
>>Barbara (playing devil's advocate again)
>
>You can also create a users table and RLOCK the relevant record when user logg in. On exit , just unlock. You can get the logged-in users by checking locked records. This works even if system crash.
We tried this, and found that there was a 5-20 minute wait for the record to be unlocked when we simulated a crash by pulling the plug on the computer. On a couple of occasions, we had to use Network Utilities to unlock a record.
Not acceptable to users, so we went with other methods.