Resetting hyperlink to newly mapped drive

[Don]

In Access 2003, I have a data field into which I enter a hyperlink to
a PDF document. The hyperlink shows as a network path to drive G on
Server1, which is the actual location of the docs.

I will have thousands of these docs, and each will have its own
hyperlink.

The location of these docs will be changing soon to drive H on
Server2. Is there a simple way (akin to Find And Replace) to change
the path of the link to reflect the new location ( a different drive
on a different server) of each document?

I was hoping to avoid manually navigating to the new network location
using Browse, for each of thousands of docs.

Thanks for your ideas.

 

[me]

Have you tried an update query:

Update Old link to:

"H on Server 2" & mid(current hyperlink,start, len -
numbchar)

simply replacing the old part of the hyperlink with the
new reference??

 

[Don]

No, I haven't tried that. I'm an Access newbie. So that command should
be entered on one non-wrapping line in an Update Query dialog box, I'm
guessing.

I will try to do that. Thank you.