Access 2000 App doubles in size while runnng

[sgloden]

I have a large Access Application with plenty of VBA code. When the application is running it continually increases in size and slows way down. I have tried many suggestions to eliviate the issue such as repair and compact, splitting the database, importing frontend objects again, etc. All of this decreases the app to a manageble size, but once the app is open and running it starts getting large very fast again.

Any suggestions on what to do at runtime would be greatly appreciated.

Thanks!

 

[cmmrfrds]

You must be doing something in your vba code that is hanging on to memory. Do you destroy all objects that you create in the code.

Set the object to Nothing when done with it.

Typical is recordset and connection.

rs.close
Set rs = Nothing
cn.cloe
Set cn = Nothing