up vote 0 down vote favorite
share [g+] share [fb]

I have an access report that comes up in a few seconds in the preview mode. When I try to print it takes about 45 seconds to print. Any ideas why this might be? This is done in Access 2003.

Thanks, Paul

link|improve this question
47% accept rate
You're unhappy with 45 seconds? – David W. Fenton May 24 '10 at 16:21
The fact that it comes up almost immediately in preview mode tells me there might be a problem. – BoundforPNG May 25 '10 at 3:48
Your printer is likely the bottleneck, since printers are by definition slower than RAM in a PC. – David W. Fenton May 25 '10 at 17:43
feedback

1 Answer

up vote 0 down vote

How large is the report? What printer are you printing to? To determine whether the printer is at fault or something else, you could try installing PDF Creator (Windows printer driver that outputs to PDF files rather than a physical printer) and see if the report is "printed" faster to that. Once you've created a PDF of your report, try printing that PDF to your printer. Does that take 45 seconds?

Check the properties of the printer driver installed on the Dell. Is it outputting text as graphics? Some settings will create much larger spool files, which on a slower computer with a slower hard driver, will take a lot longer to print.

link|improve this answer
The code behind the report can take a different path based on whether the final destination will be the screen or printer. If the virtual printer produces the document quickly it is probably the report that is at fault. – ta.speot.is May 24 '10 at 10:58
One thing I have noticed is that the customer is on an older Dell. It takes about 2 seconds on my newer computer going to the same printer. – BoundforPNG May 25 '10 at 3:57
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.