>Don,
>
>For REMOVE to work, the Database must be opened EXCLUSIVE.
>Could you use a FREE table for this?
>
>Regards,
>Jim N.
Don West.
>>
>>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.
Here is a try using EXCLUSIVE. Still, same error. ????
Thanks. Don
THISFORM.Check9.value = 0
CLOSE DATABASES
OPEN DATABASE ims EXCLUSIVE
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")