Update hyperlinks (changed drive) ...

[m.cringle]

Hi folks!

I have had to move all my files onto another drive on the network and
therefore, all my hyperlinks are kaput!

Can anybody tell me the easiest way to change the drive letter on all
the hyperlinks (I have about 2 or 3 thousand!).

I have tried using the find and replace tool but unfortunately the full
file paths are not displayed - so no joy.

Any help you could give me would be greatly appreciated

 

[JustinP]

Maybe something you could do it add a new field to the table and use
the replace function in an update query to change the drive letter.
Then just delete the old field and rename the new to the same as the
old.

In SQL View of update query (lets say the change is from M drive to G
drive):

UPDATE Table SET Table.newField = Replace(Table.oldField, "M", "G");

 

[m.cringle]

Unfortunately no luck - this method just replaced all the M's with G's
(in my case P's with S's).

Any more ideas? Is there not a hyperlink manager or something?

I would have thought that broken links was a fairly common problem.

 

[Douglas J. Steele]

No, there's no hyperlink manager. However, Justin's suggestion was a little
drastic. You need to include the colon as well!

UPDATE Table SET Table.newField = Replace(Table.oldField, "M:", "G:")

 

[m.cringle]

It didn't work but at least it didn't change every M to a G! ;-)

The problem is that the hyperlink is too long to display all the text -
the start of the link is replaced by ...... hence no drive letter to
change.

I think I might just try to get IT to change the drive permissions -
will be much easier!

Thanks anyways