We currently import and save images in our DB which are then used to create PDF reports (with images) for our cutsomers.
The problem that we encountered is the DB size of 2 GB.
So, to circumvent the size problem, we are looking into using hyperlinks in place of images in the Attachment fields.
However, before we embark in that direction, does anyone have experience with creating actual PDFs within access using hyperlinks in the Attachment field? Can this actually be done?
As I noted above, with images loaded directly into the DB, I can create PDFs without any issues. So, my concern is that the hyperlink may not be recognized as an image in the creation of the PDF document. If so, how can that be resolved?