Changing hyperlinks for 1000 records

[Guest]

Hi,

I have a table with a field called lab results. In this field is a
hyperlink path to a location on our server. The path is \\Fileserv\Company
A\Lab Results\Joe Smith. Our network administrator recently made a change by
placing data between fileserv and company A. So the new path is
\\Fileserv\data\Company A\Lab Results\Joe Smith. I have about a thousand
records in this field all with the same old path but a different name for the
person at the end of the hyperlink. Is there a way to edit all hyperlinks at
once and place the word data in all of them?

Thanks,

Chuck

 

[Jeff Boyce]

Chuck

After saving a backup copy, have you tried using the Search/Replace function
when you have the table opened?

Regards

Jeff Boyce
Microsoft Office/Access MVP