Yuri,
Thanks for your input. The files that are created are permenant tables. See my response to Mike in this thread on handling old temp files.
John

>I believe that sqlexec creates a cursor (in VFP meaning, saving result in the temporary file, physically existing on the disk). And for some reason the temporary files are not removed automatically upon quitting VFP. Usually it happens if the program abrupts abnormally or with CANCEL command.
>
>If it is the case, then the only option is to clean up the temporary path, say, on the start of the program.
>
>>I am reading an Access database from VFP.
>>I just realized that the program that has been working fine for several months now (thanks to much help from the kind people here) has been creating Tables and not Cursors. Dum assumption on my part but... Is there any way to have the results go into a cursor and not a table? I am using the line
>>
>> mresult = sqlexec(mMdbHandle, mCommand, mCursor)
>>
>>where mCommand holds the SQL statement and mCursor holds the name of what I thought would be a cursor. The temp files are ending up in the main folder on the server and have caused one or two collisions. This is not a show stopper because I can change the code to put them on the local drive in a temp dir but I was just wondering if it was possible. (I hate temp tables cause they make a mess although we have a rtn at startup to clean out any over two days old.)
>>TIA