What backend are you using? I remeber having a similar problem with a data retrieved from one specific SQl Server 7 table awhile ago. Unfortunately, I don't remember how we fixed it. Did you try to install the latest ODBC driver.

>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