Don,

For REMOVE to work, the Database must be opened EXCLUSIVE.
Could you use a FREE table for this?

Regards,
Jim N.
>>>Because I have been having difficulty getting the SELECT *; Inner Joins
>>>to work in one SELECT statement, I have had to resort to the following
>>>code. It works and merges all the tables correctly in Cursor3. I
>>>cannot get VFP 5.0 to remove the 'ourdata' table. It produces an error
>>>message 'Cannot access the cursor' when it reaches line 5, the REMOVE
>>>TABLE ourdata DELETE statement. If I can remove ourdata, then the INTO
>>>clause of the last SELECT will work. Any ideas? Thanks. I cannot
>>>get at the Universal Thread mail messages today. The Internet must be
>>>very busy. dowe@itsnet.com. Don West.
>>>------------------------------------------------
>>>THISFORM.Check9.value = 0
>>>CLOSE DATABASES
>>>OPEN DATABASE ims SHARED
>>>USE ourdata
>>>REMOVE TABLE ourdata DELETE
>>>SELECT *;
>>> FROM ims!examdata LEFT OUTER JOIN ims!classes ;
>>> ON examdata.classid = classes.classid ;
>>> INTO CURSOR cursor1
>>>SELECT *;
>>> FROM cursor1 INNER JOIN ims!students ;
>>> ON cursor1.studentid = students.studentid ;
>>> INTO CURSOR cursor2
>>>SELECT *;
>>> FROM cursor2 INNER JOIN ims!instructor ;
>>> ON cursor2.instid = instructor.instid ;
>>> INTO CURSOR cursor3
>>>SELECT *;
>>> FROM cursor3 INTO TABLE ourdata
>>>BROWSE
>>>*goApp.DoReport("reports\ourdata.frx")
>>
>>How does ourdata get added to the DBC? remove won't work unless it's in there...
>
>I originally added it manually with the New table without any data. I also included it in the project. So I know it's out there. I have browsed it.