I have a SELECT statement whose results are being put into a cursor called TmpAsses. Immediately after the SELECT statement, I scatter some of the results to memory variables. I then close the cursor by issuing a "USE IN TmpAsses" command.

This works fine for several thousand iterations. Occasionally, however, I get a "File is in use" error (#3) that occurs on the SELECT statement. It's as if the "USE IN" command failed and Foxpro simply "forgot" about the cursor. It seems to happen randomly at different locations in the data set. It is not limited to that one SELECT statement - the program has failed on others as well. I've often had success in restarting the machine and rerunning the program, but sometimes that doesn't even do the trick. I've even tried it on different workstations. All the data and temporary files are stored on the local machine and there has always been plenty of space available on that drive.

Any ideas or suggestions?