URGENT : Database Size increase in VB 6.0

[M.Anand]

Hi


I am using MS-ACCESS as the backend with VB 6.0. I open a RecordSet and do some Select operation. The Memory usage increases during this operation. Later I close the recordset and set the object to Nothing. But the same amount of memory is not freed again . For ex if 44 bytes were used for a single OpenRecordset only 20 bytes are released when I close it.


What could be the problem ?


Anand

[Vinayak Sapre]

It could be because Access might be caching some objects needs for database operation. But this is just a wild guess.