>I am working on part of our system update program that goes through every table in the system and copies deleted records to a backup folder. It runs in a scan loop, opens each table checks the table structure against an existing backup table (that accumulates the deleted records each time it is run) and creates a new table structure if needed. It all works just fine except that I just realized that all the backup tables wound up in the DBC. This is because most of the normal tables are in the DBC and it's open during the process.
>
>If I do a CLOSE DATABASE then all the tables including the cursor driving the operation will then close.
>
>Suggestions anyone?

CREATE TABLE Whatever FREE ...