>I'm stating the obvious here, it's likely you're not missing this :)
>
>Unless you yield processing to other programs, VFP can be a CPU hog.
>Particularly in an SQL Select statment (where you can't do anything about it).
>If your program is sitting in the background, waiting for something to happen, then don't run code. I wouldn't run in a loop checking time(), or use INKEY().
>
>Instead use a Windows API call to Sleep for a while, to let other programs use the CPU.


The program is doing a lot of stuff updating tables, SQLSelects, checking data etc. It is never idle for the period it runs.

I just noticed the 100% CPU usage and was wondering whether it was possible to limit this usage on a server like WIN2k as other processes will be running at the same time.

Bernard