Edit multiple hyperlinks

  • Thread starter Thread starter wayne
  • Start date Start date
W

wayne

I have an existing database with hyperlinks in each record. The files
associated with the hyperlinks have moved. How can I update the hyperlinks
in the entire database to fix them? The file names have not changed, just
the locations.
 
If they all have changed to the same location you can use an Update query
and change all the hyperlinks at once. Otherwise, you need to go record by
record and change the hyperlinks one at a time.

Steve
(e-mail address removed)
 
I have an existing database with hyperlinks in each record. The files
associated with the hyperlinks have moved. How can I update the hyperlinks
in the entire database to fix them? The file names have not changed, just
the locations.
Click to expand...

A Hyperlink field is simply a memo field containing the (specifically
formatted) text of the hyperlink. You should be able to run an Update query
updating the hyperlink field to:

Replace([hyperlinkfield], "E:\oldpath\", "K:\NewFolder\newpath\")

or whatever change is needed.

As Steve says, it's more work if you don't have just one change to make.
 
Back
Top