>>>...It is acting like a badly constructed query, but I know this query works fine because it completes on my development machine in less than a second. Can you think of any other suggestions? Thanks.

>>>Are you both running against the same data? Is there a diffference between the ST DELETED or SET EXACT settings on the machines? Is the hardware, CPU and RAM, the same? What else is running on the production machines when the fox app does its query? The production machines may be hitting the windows swap file alot.
>>
>>Hi Jim,
>>
>>Yes, the database is the same for both. Set settings are SET DELETED ON and SET EXACT OFF in the main.prg. Actually the RAM is more and the HD space is larger on the user's machines than on my development machine. I've tried only running the fox app with nothing else on the users machine with the same results....

Is the data on a network server? If so, are the users on the same part of the network as you?