>>Real-time AV scanning hooks deep into the file system and can intercept/delay read (and/or write) requests while it does its scanning. It's possible that VFP may occasionally write a cursor to disk; delays due to scanning may get interpreted as "file does not exist" or "alias not found".
>>
>>Disabling real-time scanning for just your temp file folder may be enough to test this theory.
>>
>>There may also be other processes that hook into the file system e.g. so-called "real-time" backup/mirroring utilities.
>>
>
>
>>READWRITE does not necessarily force a file to be written to disk, NOFILTER does. It might be interesting to experiment with adding NOFILTER to your query.
>>
>
>Al,
>
>I believe the last statement is incorrect. Readwrite does the same as NOFILTER.
Where do you see that information? I read the help for SELECT - SQL before I posted.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up