Discussion and code in thread #717454 could give you the idea.

>Hi,
>
>We have a FoxPro application that is automated to run every night. The application requires exclusive access to the tables.
>
>But sometimes we have problems because some user did not log off correctly from another FoxPro application that uses these tables. And the automated program crashes with 'File access denied' errors.
>
>We are trying to improve the automated program so that it makes another attempt to execute the code and if it fails on the 2nd attempt, it restores data to the tables from a back up.
>
>But if this a 'File access denied' problem, we are still going to have the problem on the second attempt, unless we make sure that everyone is off of the tables. Usually our systems team, monitors the application and if it fails with 'File access denied' errors, kicks off all users on the system and restarts the automated application.
>
>Is it easy to incorporate the systems job into the program? or how can I find out who is on the system? and how can I kill that user session through FoxPro?
>
>Any suggestions will be greatly appreciated.
>
>Thank you.
>
>Ria