Edit multiple hyperlinks

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.
 
S

Steve

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
[email protected]
 
J

John W. Vinson

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.
 
Top