Insert PDF Document Object

[jeremie_ingram]

There is no major importance to this, but a major amt of curiosity. I noticed under the INSERT then OBECT menu selections, there is ADOBE ACROBAT DOCUMENT. Now, I would think that this would allow for an individual to include a page or pages of a PDF document to be inserted into the report that you are working on. However, all I can get it to do is create a little adobe icon on the report. Looking in help and online hasn’t produced much, so I thought I would ask the great minds of this forum for enlightenment.

 

[kgrabske]

Any more info

Jeremie,

Did you ever find any more info on linking an acrobat file in an access report? This would come in handy for an application I'm working on.

Thanks,

Keith Grabske

 

[jeremie_ingram]

Well, I have not found an easy way to intergrate the PDF INTO Access, however with Adobe 6.0 pro full, you can impliment ADBC. This is similiar to the ODBC use within Access, and will alow you to use access data to create completed forms in PDF file format. You need the full version for it to work though, since Adobe reader does not allow you to use the ADBC or the "spawn" (auto form generation) commands.
It can be done, and I have done it. Check out THIS SITE and search the forum for "spawn" "ADBC" or "Horse". I had a topic there called "Hate to beat a dead horse" under Beginers. See if that is what you are looking for.

 

[kgrabske]

Jeremie,

Thanks for the response. All I need is for an access report to contain and print the contents of a specific pdf file. We have a bunch of engineering drawings (blueprints) scanned in and saved as pdfs. I want to include a small view of the corresponding pdf when printing a manufacturing routing report for a given part. If these pdfs were jpegs or tiffs instead, this would be really simple. I was hoping there was a simple control (which there appears to be) that would enable similar linking to a pdf. Maybe I'll just convert all of the blueprint files to jpeg for this project.

Thanks again,

Keith Grabske

 

[KKilfoil]

I have been wanting to do that precise thing for more than a year now, but i have yet to discover a way to do it!

I too have assorted existing pdf files that I want to include in reports. I don't want to store the contents of the pdf file in Access, and I don't want to have to convert the pdf to a jpg or other format that Access seems able to deal with, as it tends to make the files bigger, often degrades quality, and adds extra steps to the process.

 

[aliaanderson]

For the conversion of PDF you may visit at softonic pdf - to - jpg - convert . en . softonic . com will be the simplest method to convert the file format.