Programmatically creating Postscript and PDF files

[jasbrown]

I routinely create hundreds of departmental reports. Each departmental report contains numerous reports for each of its sub-departments. I create these reports in MS Access and then use VB to generate postscript files.

I then distill these files using Acrobat Distiller. Once distilled I end up with one PDF for each department. Within the PDF there are bookmarks for each of the sub-departments that role up under it. Each bookmark correctly displays the associated sub-department's report. It has been working perfectly for me for years. However, I recently upgraded from Acrobat Distiller 6.0 to Acrobat Distiller 9.0.

Now when I distill the files it no longer pulls the sub-department reports into the PDF file. I end up with a PDF file for each department, containing all of the correct book marks, but no reports. Each book mark is simply a blank page. I am not sure how to correct. Can anyone assist me? I do have a post script for each report. So I could distill each report individually, but the whole point is to have one PDF for each deaprtment containing all of that department's reports.

 

[genomon]

We use this:

http://www.groupacg.com/

Click on the "Tools for Access Developers" link and check out the PDF and Mail Class Library.

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[jasbrown]

genomon,

Thank you for your suggestion. If I have to, I will break down and buy the software package to do what I need as you suggest. However, I have written my own and it has been working perfectly for all of these years. I am not sure what changed from Distiller 6.0 to Distiller 9.0, but I hate to spend money on a new software when it is likely something as simple as one setting that needs to be adjusted or one line of code that needs to be added.

Thanks,
Jason

 

[genomon]

Just FYI it's only ten bucks. It's not a software package, it's a runtime library, basically.

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[jasbrown]

Genomon:

I must not be looking at the same thing you are. According to the site it looks like it is going to cost me $99.

http://www.groupacg.com/acgpdf.htm#Order

Thanks,
Jason