I took this same approach in an application I'd done. I overcame the "user shutting down with out exiting" problem by having the app update the record every 5 seconds or so via a timer. This way, The table could be cleared, then anyone still logged in would re-appear in a few seconds. Not pretty, but it provided basic functionality.

However, we have numerous people working with our FoxPro data outside of the Application (Crystal Reports, etc.). Of course this bypasses the system. It would be great to be able to tell if anyone was using a particular file directly.

>
>we've thought of that, but have a problem with users [1] turning their machines off without exiting the program and [2] leaving their machines on all night with the program running.
>
>we've solved [2] by adding a timer the the apps to close them after a set time of inactivity, but [1] would leave that flag on after they've quit the system.