I have created an application that uses a database with many different recordsets/tables. During the running of my app i notice the functionalities are getting slower. I am thinking that I maybe using up the RAM with my variables and controls etc....

I thought i was fushing out the mem by using the code: Set rsRecordVar = Nothing

Is there a way I can measure the amount of RAM a particular variable/control is using at one time. Just to allow me to identify the code area that causing the slow down.

Thanx

clax