Memory Leaks w/ADODB recordsets

M

Michael Henry

Hello,
I'm have written a class module that opens and closes
multiple ADODB recordsets. With each recordset I'm using
the xxx.close followed by "Set xxx = Nothing" once I'm
done using it. However each time that the code is
executed my memory counter continues to rise. If
MSAccess.exe in the task manager starts at 30,000K it
ends at 75,000K. Can anyone explain why this is happening
or a possible solution as to what I may be missing in my
code.

Thanks
Mike Henry
 
Top