Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question
    
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. –  Paul 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
add comment

1 Answer

up vote 0 down vote accepted

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.

share|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. –  Paul May 25 '10 at 3:57
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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