my program uses CDatabase and CRecordset objects in multiple threads and very frequently. The problem is that memory doesn't seem to be released when I close the database. I do see memory decreasing when I close my recordset objects but not the database.
Also, everytime I call CDatabase->ExecuteSQL for an INSERT query the memory and handle count goes up. Is there some other mehod that has to be called to release resources. Note that I am using CDatabase to connect to a MS Access database via ODBC because it is more thread safe that CDaoDatabase.