How to import pdf file?

[rodneyb]

Hi,

Is it possible to store a pdf file onto an Access97 database?

I have a client who wants to be able to use their Access97 application to import pdf documents using an access form as the interface (ie click a button to import a doc and click another button to view the imported doc).

I found this code which would work:

stAppName = "C:\Program Files\Adobe\Acrobat 4.0\Reader\AcroRd32.exe"
Call Shell(stAppName, 1)

And then I guess I could pass the file name as the second argument to stAppName which would open the file I wanted.
But this functionality requires the pdf file to be stored outside the database, and I was wondering if it is possible to store the pdf inside the database? Also what are the implications if any?

Thanks,
Rodney.

 

[Parker]

Hi,

Hi Rodney

Why would you want to store a .pdf in your db?

I would just create a table to hold links to the file and store the file elsewhere.

Doing this you can give the file links meaningful names and use a pick list.

HTH