We have an app using DAO and Jet 3.5.

We use CDaoRecordset.
We have a routine which populates a recordset with about 20,000 records
using AddNew(),SetFieldValue() then Update() in a loop.

This routine seems to really chew up memory and never gives it back until
the app itself closes.

We explicitly close the database and the recordset.  I've tried changing
maxbuffersize.  Nothing seems to affect the memory it uses.  The system
eventually dies.

I would appreciate any insight.

Thanks
Dean Kotchka

We have the same problem using CRecordSet and an ODBC Accessdriver.  The
database-threads seems to continuously allocate memory which is not freed.

Peder Sperstad

We have an app using DAO and Jet 3.5.

We use CDaoRecordset.
We have a routine which populates a recordset with about 20,000 records
using AddNew(),SetFieldValue() then Update() in a loop.

This routine seems to really chew up memory and never gives it back until
the app itself closes.

We explicitly close the database and the recordset.  I've tried changing
maxbuffersize.  Nothing seems to affect the memory it uses.  The system
eventually dies.

I would appreciate any insight.

Thanks
Dean Kotchka