I have an Access 2002 application that is running VB/DAO to manipulate data and have very few forms. When the application starts its size is about 20,000 KB. After completion of a run 4 hours later, it can grow in size to over 200,000 KB. And as the run progresses, it gets slower and slower which I suspect is related to this growth. I close all open recordsets and set the database and recordsets to nothing prior to exiting a procedure.
Any insight as to what is happening with this growth or how I can track down the problem?
May 6, 2009 3:23 PM
April 21, 2012 1:52 PM