>>P.S. CR 9 works find VFP 8 if you use ODBC and don't try and use the autoinc data type.
>
>We've had a couple problems with CR9 and VFP8 (don't know about CR9/VFP7):
>
>1. CR9 keeps data files open even after the RDC and Report objects are set to NULL. This can be reproduce via OLE DB, ODBC, VFP8, VB .NET, ACCESS. In my applications, I use temp tables for reports (I delete and recreate these tables between printouts). With CR9, it keeps the data files open and I cannot delete them unless I close out of the application - CR says this is by design, but I'm fighting it all the way to the top. In CR v7, we had to open a different report to release the data files from the previous report. In CR v8 and v8.5, the data files closed with the report (which is the way it should be!). In CR9, nothing will close the data files and I'm having to rewrite my logic to work with the tables that cannot be deleted after they've been used by a report. AARRRGGG!!!!!!

Bill,

I just tried doing this and didn't have any problems deleting the report table.