Click to See Complete Forum and Search --> : URGENT : Database Size increase in VB 6.0


M.Anand
March 7th, 1999, 11:52 PM
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
March 8th, 1999, 02:36 PM
It could be because Access might be caching some objects needs for database operation. But this is just a wild guess.