Code is fairly simple. Sending out emails to a bunch of customers (roughly 600) with an attached report. It basically is a do while loop using the record and using the following. DoCmd.OutputTo acOutputReport, stDocName, acFormatPDF, FileName & ".PDF", False
Everything works fine but the memory just keeps climbing after each email and then it dies and says insufficient memory to process.
While watching it run under task manager under vista, you can see the releasing of memory on each report. The memory creeps up a small tad but nothing like it does under the newer version. The older version creeps up maybe 1 meg for 10 reports. So over 600 maybe 60 meg. The newer version, approx. 1-3 meg for every report and it basically just kills itself.
This is for an ADP.
Like I said the process is as follows:
1) get recordset of all customers
2) loop for each customer.
a) get email and customer attributes from recordset
b) execute docmd and create report.
c) email report.
3) Go get next customer.
Thanks. I have 2 databases left to convert over before I can rid of the Vista machine. Stuck right now.
Remember when... everything worked and there was a reason for it?