Need Access to generate smaller PDF

I have a module generating and attaching my reports to email. I have just upgraded from 2007 to 2010 (Acrobat 9 to Acrobat X) and my PDF size has gone from 300K to 800K. I need the file to be under 500K. I can manually export to a smaller PDF but through the module it just will not work. Any idea's? Thanks (See module code below)
Function send_emailcap_mtd()
   On Error GoTo Err_Send_Click
    Dim mydb As Database, RS As Recordset
    Set mydb = DBEngine.Workspaces(0).Databases(0)
    Dim attachPDF As String
    Dim docname As String, ctl As Control, strTo As String
    Dim path As String, subject As String, body As String
    Dim attach As String, blnSuccessful As Boolean
     Application.Echo False
    Set RS = mydb.OpenRecordset("qry_emailcap_mtd")
    path = "c:\temp\"
    docname = "emailcap_mtd"
    attachPDF = path + docname & ".pdf"
    subject = "Email Address Capture Report"
    body = "Daily Report is Attached"
    DoCmd.OutputTo acOutputReport, docname, acFormatPDF, attachPDF
 Do Until RS.EOF
      strTo = RS!Email
       blnSuccessful = FnSafeSendEmail(strTo, subject, body, attachPDF, "", "")
    Set RS = Nothing
    Set mydb = Nothing
    Application.Echo True
    Exit Function
    Resume exit_send_click
End Function

Open in new window

Cole100IT Systems ManagerAsked:
Who is Participating?
Jeffrey CoachmanMIS LiasonCommented:
Then I am not sure.

1. Why must the size be below 500k?
There may come a time when the PDF format just may not produce files small enough anymore.

I mean, I would always stick with any built in utility.  In the overall scale of file sizes, 500k to 800k is not that big of a deal in most cases.

2. If the increases in file size is really intolerable, you may want to check with the manufacturer of your 3rd party vendor for an update for 2010.

(But be warned that since Office now includes a PDF utility, may of these small apps might no longer be issuing updates...)

Again, what is the story behind the 500k hard limit?

I haven't personally played with Acrobat X yet, but if there is a way for you to set an option to save PDF in the Acrobat 9 format as a default. If not check Acrobat X to see if there is a way to set compression rates to maximum as a default.
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Since you are using this code:

DoCmd.OutputTo acOutputReport, docname, acFormatPDF, attachPDF

Open in new window

would indicate that you are not using Adobe Acrobat to create the PDF but the built in PDF feature in Access.  Is this correct?

In my test with Access 2007 and 2010  PDF  using the built in PDF tool the files were the same size.

have you made any changes to the report design recently?

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.

Jeffrey CoachmanMIS LiasonCommented:
...or is the report simply displaying different number of records?

For example:
Your first report was of sales in Tuvalu (6 records), and the second Report was Sales in China (60,000 records)

Cole100IT Systems ManagerAuthor Commented:
I am using access' built it PDF converter. With Access 2007 I was using a 3rd party converter so I would imagine that would have an effect. The 3rd party converter I was using does not work for 2010. Otherwise the report itself is exactly the same. I do not see anywhere in access to change compression of the PDF.
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
I have just learned from an Word MVP that a PDF show now include  tagges so that screen readers can readt the file for accessibility complaiance. My understanding is that Microsoft must make sure thier PDF output is compliant. Thus the file size will increase.

This new accessibility complaiance will be an issue for all third-party vendors that make PDF writers. So I expect the PDF will size to increase accross the board.

Cole100IT Systems ManagerAuthor Commented:
The third party vendor I was using does not support 2010 and I am not having much luck finding anything else. The built in PDF generater works great other than the file size issue. Based on my research I am beginnning to think PDF will only increase in the future. (In the world of superfast internet speeds and multi-GB jump drives then why not)

The 500k limit is because my stores are on a VPN (which I have no control over) and they limit the email attachment size.
Jeffrey CoachmanMIS LiasonCommented:
Then you may have to think about compressing (zipping) the files first...
Jeffrey CoachmanMIS LiasonCommented:
...or ask the powers that be to increase the email attachment size.

I mean, most files (Formats) will only get bigger and bigger with time.
So this hard limit will only become more and more annoying...

In other words, ...endeavor to solve the problem (easy), instead of "Working around it" (More difficult)
Jeffrey CoachmanMIS LiasonCommented:

Thanks for the update on the PDF format..

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.