Memory Leak when using OpenReport

S

SNEC

I have a system that prints a report once an hour and 5 reports once a day
That is 29 reports a day. I use the VBA command DoCmd.OpenReport to do the printing
After a while the system locks up due to out of memory

Using the Windows performance monitor I can track how much memory is being used over time. It seems the that everytime OpenReport is called, the system uses up a chunk of memory. The % committed bytes eventually moves to 100 percent and the system crashes

I use the Quit command and set all my objects to Nothing at the end of my VBA routines. I also use the CloseReport command after printing. Any reason why I can't release the memory
This does not occur if I comment out the OpenReport command. I am using Windows 2000 and Access 2002
 
B

Bryan Reich [MSFT]

Just to be sure I'm understanding, you actually quit out of the entire
Access application after each report print? Where are you launching access
from, is it from another application using script as well?
--
Bryan Reich
Microsoft Office
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm


SNEC said:
I have a system that prints a report once an hour and 5 reports once a day.
That is 29 reports a day. I use the VBA command DoCmd.OpenReport to do the printing.
After a while the system locks up due to out of memory.

Using the Windows performance monitor I can track how much memory is being
used over time. It seems the that everytime OpenReport is called, the system
uses up a chunk of memory. The % committed bytes eventually moves to 100
percent and the system crashes.
I use the Quit command and set all my objects to Nothing at the end of my
VBA routines. I also use the CloseReport command after printing. Any reason
why I can't release the memory?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top