>>Recently a user has reported an intermittant problem that appears to be related to the indexing of a local view. The code in question has been running for years w/o issue. The errorlog is reporting the error as "FILE IS NOT OPEN" and it appears to occur on the INDEX line below:
>>
>>

SELECT v_myview
>>DELETE TAG ALL
>>=requery("v_myview")
>>SELECT v_myview
>>=cursorsetprop("BUFFERING",3)
>>INDEX ON UPPER(lastname) TAG lastname   &&   <<=== error 

>>
>>Although the logged error reads "FILE IS NOT OPEN", the view in question is open.... according to the collected list of open tables/views also stored in the errorlog details.
>>
>>Assuming that the reported error is in fact THE error, I had suspected that a CDX write issue was involved. There's housekeeping code in place that deletes 2 day old *.TMP files from the temp folder (on the user's C drive). However, i realized that the housekeeping code was deleting just TMP files and that a good number of CDX files (now deleted) were still in that folder.
>
>Is it possible the housekeeping code could be running while you're also trying to run the above code?
>
>Could there be lots of other temp files in the temp files folder other than .TMP or .CDX? Try manually cleaning them out if so.
>
>Run CHKDSK on any local drive that might be involved with your app, make sure file system errors aren't causing problems.
>
>Finally, if any antivirus is running, try testing with at least the real-time scanner portion disabled, or any VFP-related folders/files excluded.

Thanks for the reply. The temp folder has been cleared and the housekeeping code is now cleaning up CDX files as well. I dont believe there's a contention problem. The housekeeping code runs at startup and it looks for 2 day old files or later. I believe they were running one session of the exe and had just one copy of the form open for that session. It started happening at this site approx 3 days ago, and it was occuring maybe twice a day. Waiting to hear back from them. No word so far today.