Update Hyperlinks

[rfreeman]

I have a table with over 2000 hyperlinks contained in a field. We recently added a new server and moved the base location of all the files referenced in the hyperlinks. Is there a way to globally edit all the links to the new location? All comments appreciated.

Thanks,
Ryan Freeman

 

[sfreeman@co.mer]

update query

You should be able to do it with an update query.

FIRST, DO THIS ONLY ON A BACKUP COPY OF YOUR DATA TO MAKE SURE IT WORKS AS EXPECTED.

For example, assume a table called tblLink with a hyperlink field called Link.

And, assume that you have a value in the field of "http://www.access-programmers.co.uk"

and you wish to change that to "http://www.access-programmers.co.us"

The value is 36 characters in length, so you want to change only the last two.

UPDATE
tblLink

SET
tblLink.Link = Left([Link],34) & "us";

Obviously, this is not your situation, but you should be able to adapt this to fit your needs using various string functions.

HTH

 

[Len Boorman]

Not disagreeing with anything but a small something to watch out for.

Depending on the method you use when actually firing a hyperlink be aware that the hyperlink string that is generated probably/possibly contains an embedded # at each end of the string. It is also not visible.

If you run into a problem with the adfvice you have been given then consider the above.

Sorry but cannot be more precise about this cos its not something that I have fully explored. I only know that when generating a hyperlink from code I had to add #'s to make it work when clicked. Other's use Follow Hyperlink method and that seems to be okay without #'s.

Len B