[DB-SIG] How to close FoxPro tables opened with ODBC

[Bob Gailer]

I define an ODBC data source using the Microsoft FoxPro DFP Driver.
I create a connection using this data source, with the odbc module
I create a cursor, and use it to execute a query.
The tables referenced by the query are now "tied up", in that I 
can't  erase them (Access denied).
The only way I've found to close them is to close the Python session.

Is there a way to close these tables without quitting Python?

Bob Gailer
bgailer at alum.rpi.edu
303 442 2625 home
720 938 2625 cell