The help on CLOSE TABLES says:

a) closes all tables in the active database. Closes all free tables if no database is open/choosen.
b) don't use with transactions, as this will throw an error.

CLOSE TABLES will close a cursor, if it is just a filter to a table of the active database, but leaves it open as it does with free tables, if it is a "real" cursor. The difference is DBF("alias") is a table file name, if it is a filter, but DBF("alias") is the name of a TMP file, if it's not a filter.

What you wanted maybe was CLOSE TABLES ALL, which closes tables of the active database and free tables or cursors, but leaves open tables of other databases. And if you really want to close all, then use CLEAR ALL, or switch to each database ADBUSED() gives you and CLOSE TABLES ALL, as CLEAR ALL of course clears a bit more than just the active datasession of all open tables.

Bye, Olaf.