?
Solved

Access 2007 Report to PDF

Posted on 2011-10-12
8
Medium Priority
?
253 Views
Last Modified: 2012-08-13
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.
0
Comment
Question by:bvanee1
  • 4
  • 2
  • 2
8 Comments
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 36959749
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
 

Author Comment

by:bvanee1
ID: 36961253
Yes you are correct, that is what I was doing.  I will try to do it directly and see what happens.
0
 
LVL 59
ID: 36961499

 Make sure the app is compiled.

Jim.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 59
ID: 36961510

 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
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 36964845
Rather than open the report in preview use

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

Kelvin
0
 

Accepted Solution

by:
bvanee1 earned 0 total points
ID: 36964944
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
 

Author Closing Comment

by:bvanee1
ID: 36984654
Not the only solution, but given my circumstances it works.
0
 

Author Comment

by:bvanee1
ID: 36964959
Closed
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question