To keep my dB under 2Gb I have created a hyperlink field that directs to a series of folders containing hundreds of pdfs. Keeping the pdfs as attachments in Access blew the file size.
My problem is that when I transport the database and linked folders to a new location, ie to a clients computer, the links are no longer valid. Is there a way to simply automate this process so that when the dB and associated pdf folders are transported the hyperlink connects to the folders in the new location.
Thanks,
Andrew
My problem is that when I transport the database and linked folders to a new location, ie to a clients computer, the links are no longer valid. Is there a way to simply automate this process so that when the dB and associated pdf folders are transported the hyperlink connects to the folders in the new location.
Thanks,
Andrew