Out of Memory????

[dirkg]

Hi all,<br><br>I have a problem with a batch program I'm running. This program is calculating results on data which are stored in several tables. As long as I run the batch-program on a small amount of data it works fine. However, when I run it on a large amount of data ( this means that the same calculations are done over and over again a lot more times) the program becomes slower and slower (I can check the time each loop takes) and finaly it blocks and sometimes the message &quot;Out of memory appears&quot;. Therefore I have the impression that my program is &quot;eating&quot; memory. First I thought it was because of recordsets that I opened and didn't close again but I made sure all recordsets are closed again before the loop re-begins and still this memory-problem persists. Has anyone an idea what else can cause this problem? It's Access 95 I'm using (yes I know it's getting quite old but switching to a newer version is not (yet) an option, and anyway I would really like to know the cause of this problem since I suppose it's a fundamental-programming error I'm making (as not closing opened recordsets was also one, but that one I learned now thanks to the people on the Tek-forum ;-)). My computer has a Pentium III processor with 192 MB RAM memory.<br><br>You would really help me a lot if you could give me some tips so thans a lot in advance!<br><br>Greetings,<br><br>Dirk<br><br><A HREF="mailto:dirk.news@yucom.be">dirk.news@yucom.be</A><br><br>PS: while the loops are running there are three recordsets constantly open because the data they contain are needed to guide the batch-process. I don't know how that is influencing memory performance but I guess they can't cause the program to slow down because they don't change in size or contents since I only use them to read data from...<br><br>

 

[cmmrfrds]

There were several posts on the &quot;Out of Memory&quot; problem the last couple of weeks. One problem in Access 2000, out of many, is that if you use the Wizard to create forms and choose any color other than standard there is a memory leak. I believe there is a patch for this which you may find in a prior post otherwise go to the microsoft site and look. Memory problems show up sooner in Win9X than NT, since NT does a better job of memory management. <br><br>If you converted the DB from Access 97 to Access 2000 that can open up other areas of problems. Best to create a fresh access 2000 database and import all the objects from the access 97 DB this will save potential problems.<br><br>Just to make sure on the 3 open recordsets, I would make then read only or Snapshot.<br><br>Jerry