How do I store hyperlink? Newbie question

[HappyBunny]

How can I store the pdf files so that when I move the whole folder to another drive I wouldn't have to change all the hyperlinks in Access?
Please help

 

[georgedwilkinson]

How can I store the pdf files so that when I move the whole folder to another drive I wouldn't have to change all the hyperlinks in Access?
Please help

When you figure this out, let me know. I'll be wanting to borrow some money from you, which you'll have plenty of.

 

[Pat Hartman]

I couldn't work it out either so rather than storing a hyperlink, I just stored the file name. The path structure was stored separately. Then in the code I concatenated the path to the file name and used the followhyperlink method.

My application needed to manage 5,000 + endorsements for an insurance application and they were divided into to categories - admitted and surplus and within those two basic categories, they were divided by product. Your path structure may be more or less complicated but once you figure out the correct structure for storing your paths, the rest falls into place.

 

[boblarson]

I couldn't work it out either so rather than storing a hyperlink, I just stored the file name. The path structure was stored separately. Then in the code I concatenated the path to the file name and used the followhyperlink method.

Great way to do it Pat! I like it and will remember that if I need to do that. I had pondered this question but hadn't thought of that idea.