I run an sql query via odbc. Then do this:

SELECT sqlresult
COPY TO c:\temp.dbf
use c:\temp.dbf IN 1 ALIAS tmptable
SELECT tmptable

scan

at this point i get an error that says: "Cannot access the selected table"
i press ok and can now use the table. Any ideas on how to avoid this?

Thanks
TomW