Access 2007 Report to PDF

I have an Access 2007 report which I am converting to PDF.  The report generates okay, but when I try to convert it to PDF it takes a long time, about 2 minutes per page.  There are some functions which are part of the query which generates the report that are a little time consuming, but it seems that it is taking an extremely long time to complete the report.  Any suggestions would be appreciated.
bvanee1Asked:
Who is Participating?
 
bvanee1Author Commented:
It was still too slow after trying all the above suggestions.  The table that was causing the issue was a linked SharePoint table.  I fixed this issue by creating a local "copy" of the table when needed, that was the select statements that were being used would process much faster.  Works like a charm now.
0
 
Kelvin SparksCommented:
What method are you using to convert to pdf? It sounds like you are trying to do it from a print preview - doing anything while print preview is open will make things VERY slow.

You should just output it directly to a pdf.


Kelvin
0
 
bvanee1Author Commented:
Yes you are correct, that is what I was doing.  I will try to do it directly and see what happens.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

 Make sure the app is compiled.

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

 BTW, outside of that, I think we'd need to see the procedures.  Maybe a way to improve those.  You also as a test could disable some of them (Exit at the top of the procedure right away or not call them at all) and see if the time substantially improves.

Jim.
0
 
Kelvin SparksCommented:
Rather than open the report in preview use

DoCmd.OutputTo acOutputReport, "rptname", acFormatPDF, "Filename", 0

Kelvin
0
 
bvanee1Author Commented:
Not the only solution, but given my circumstances it works.
0
 
bvanee1Author Commented:
Closed
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.