I create a table with:
SELECT * from parts WHERE ponum=mponum INTO TABLE partstank.dbf

After using this table as a record source for a grid, I can't get the thing to close no matter what I do, and no matter where I do it! Is there any way apart from USE to close a table?

The code I have tried is:
SELECT partstank
use

Also tried:

USE in SELECT("partstank")

After trying to close the file, I try to delete the file with:
DELETE FILE('partstank.dbf')
and get a VFP error "File in use..."

ANY ideas welcome!
Thanks!