PDF to Access (Access 97/SR2)

Topic

New Reply

Is there a way to take an Adobe 5.0 PDF form and import it into a MS Access 97 database? We were told we could do this provided we had Windows 2000, however, we are currently running Windows 95 on the desktop and it will be 6 months+ before migrating to Windows 2000.

Any suggestions are welcomed!

Reply | Quote

Replies

Set up a dedicated directory for the PDF files and place the PDF files in the directory.
You will need some files to see this process work..
You probably want to view the document in a form.

Create a text field named ImagePath in the appropriate table and save.
Set an icon’s path as the default value.

Create a form with the field ImagePath.
Place the following code in the After Update Event in the ImagePath field.

Private Sub ImagePath_AfterUpdate()
On Error Resume Next
Me![ImageFrame].Picture = Me![ImagePath]
End Sub

In the form create an Image Frame, named ImageFrame.
Make the field large as this is where you will be viewing the PDF document.
In the On Current Event Property of the Form place the following code.

Private Sub Form_Current()
On Error Resume Next
Me![ImageFrame].Picture = Me![ImagePath]
End Sub

Place the following code in the On Open event of the form.

Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
End Sub

Enter the path to the appropriate file in the ImagePath field and you will see the PDF file.
This also work with other graphic types.

This method stores the graphic file outside the database and is preferred as the DB would grow very large.

Good luck.

Reply | Quote

I have also been wondering how to do this. Does anyone have any additional solutions?

Reply | Quote

It’s also possible to drop the Acrobat reader activex control (pdf.ocx) on a form and use that to display a PDF.

Reply | Quote

As noted in previous post, you can insert the Adobe Acrobat Control for Active X on a form. Set the control’s “src” property to the full path of the .PDF file (ex: C:PDF_FilesTestForm.pdf). In form view you will be able to enter data in the .PDF form and save file, etc just as you would when working directly in Acrobat.

Reply | Quote