Questions

Problems converting Access 2003 to Adobe pdf

Tags:
+
0 Votes
Locked

Problems converting Access 2003 to Adobe pdf

swisstonihasher
Hi there,

I have an user that's created a report into Access 2003 and now wants to convert to pdf. The problem is that the "boxing" around content tables is partly missing after the conversion. Some tables have the bottom line missing or side "wall" missing. This is all done on Adobe v8 of the software.

Has anyone come across this before and found a fix?
  • +
    0 Votes
    dfmahoney

    I don't have a specific solution for your problem but here are a couple of items to test: 1. try producing the report as a snp file to test that all the formatting is coming through; 2. try producing the pdf manually using (e.g.) pdf Factory (www.fineprint.com) as a test. I produced many Access reports with this and had no difficulty with boxes or borders. This can be automated also and is reported to give very good pdf representations 3. Try larger margins.

    +
    0 Votes
    TrajMag

    If the report format is set up correct, try going to "Print" in "Files" and selecting Adobe. Then save somewhere and print the PDF as usual.

    +
    0 Votes
    swisstonihasher

    Okay thanks...

    Just finished doing the updates for latest version of adobe, will then try what you say..

    +
    0 Votes
    Route81

    I always use PDFcreator. (http://sourceforge.net/projects/pdfcreator/)
    It simply installs as a printerdriver so all you have to do is make whatever you want in the layout that you want and 'print' it to PDFcreator. You really don't have to do anything special for it.
    You can even select different dimensions of paper (from letter to A0) if desired.

    It's possible Adobe itself does the same, but this is free and almost completely transparent.

  • +
    0 Votes
    dfmahoney

    I don't have a specific solution for your problem but here are a couple of items to test: 1. try producing the report as a snp file to test that all the formatting is coming through; 2. try producing the pdf manually using (e.g.) pdf Factory (www.fineprint.com) as a test. I produced many Access reports with this and had no difficulty with boxes or borders. This can be automated also and is reported to give very good pdf representations 3. Try larger margins.

    +
    0 Votes
    TrajMag

    If the report format is set up correct, try going to "Print" in "Files" and selecting Adobe. Then save somewhere and print the PDF as usual.

    +
    0 Votes
    swisstonihasher

    Okay thanks...

    Just finished doing the updates for latest version of adobe, will then try what you say..

    +
    0 Votes
    Route81

    I always use PDFcreator. (http://sourceforge.net/projects/pdfcreator/)
    It simply installs as a printerdriver so all you have to do is make whatever you want in the layout that you want and 'print' it to PDFcreator. You really don't have to do anything special for it.
    You can even select different dimensions of paper (from letter to A0) if desired.

    It's possible Adobe itself does the same, but this is free and almost completely transparent.