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