Storing PDF file in Access (1 Viewer)

[ranchlaw56]

Is there a way to store a PDF file in Access?
I want to be able to store the file and if needed print it on request.
The database needs to be portable so linking poses a difficulty.

 

[John Big Booty]

Welcome to the forum.

You would be better off storing the PDF's in a file that is in a constant location relative to the DB. You can then use something like;

Application.CurrentProject.path & "\Your File Name"

to determine where the files are stored.

 

[John Big Booty]

Storing files directly in your DB will cause it to bloat unnecessarily.

 

[ranchlaw56]

I realize the method I am trying to use is not the "proper" or "preferred" method. In the environment this database is going to be used it is better to have everything in one file to prevent file loss.

What I need to know is if it is possible to store the PDF file in an Access table and if so how.

 

[John Big Booty]

You could possibly store a PDF file in an OLE field. However as already mentioned this is not recommended as it will bloat your DB. Have a look at this link for further comment.

 

[DCrake]

Take a look at this Link to.

 

[accessfleet]

In my MSDS table I use a hyperlink to access the material safety data sheet PDF files. Embeding the file could work but as others have mentioned it will bloat and slow down data access.

As you say, some feel safer if all the data is all in the same file, but another way of thinking about it is that seperate directories make the data safer because if something happens in one directory or file not all the data is lost.

good luck with your project.