External PDF Linking - Images in Microsoft Access


	Back to Images Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

External PDF Linking

Chuck Hobbs

5 years ago

Hi. The image video worked great to debloat my Documents DB by placing the JPG files outside of the database. However some of my documents are multiple pages and are in a PDF file and cannot be used as images.

Is there a way to "link" to those PDF files outside of my DB so that when the icon is clicked or double clicked it will open the PDF file?

Thanks,
Chuck

	Alex Hedley @Reply 5 years ago
See Access Open Other Programs Seminar

	Chuck Hobbs OP @Reply 5 years ago
Thanks for the advice. After a lot of research and almost understanding all the VBA coding that I found. It occurred to me That there is a hyperlink file type available to me. It works great for my purposes. My backend went from 127 meg to just 17 meg by putting all my jpg and pdf files outside of the database. Thanks Chuck

	Alex Hedley @Reply 5 years ago
The hyperlink field isn't great, it has problems, hard to parse etc It's better to just store the path then do an `Application.FollowHyperlink` or equivalent But I guess if it's working for you then great Plus great to hear it's shrunk so much, it's far less likely to corrupt now.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Images.

Next Unseen

New Feature: Comment Live View