hyperlinks

[bigmac]

hello all and happy new year to you all.
i have a database that has a hyperlink on the table, my concern with this is that if the folder with the linked items(pdfs) is moved to a different location then does that mean that all the links will not work? if this is so is there a way to get the links to point to correct items other than manualy doing it ( there are thousands of links ) the reason i have used links is to keep the database small in size. thanks for looking

 

[pr2-eugin]

The way I look at it, excessive coding, when all it needs is the user when moving a file needs to update the links.

 

[bigmac]

hi pr2-eugin how do i update the links please?

 

[BeeJayEff]

I have a similar concern in that I know the folder location will be different for the production system to what it is while I am developing it. My solution will be to store the path as a global string variable, and only have the filename within the record. Then concatenate the two when needed. I will then only have to change the path variable whenever the folder location changes.