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?