Find & Replace in hyperlink field

[Lars Brownies]

I've inherited a database which has a table with a hyperlink field. Each
value holds the full path to the particular file. Because of a drive
migration project, the first part of the path will change. Is there a quick
and dirty way to do a 'find & replace' on the hyperlink field?
Thanks,

Lars

 

[Tom van Stiphout]

On Fri, 19 Jun 2009 06:49:49 +0200, "Lars Brownies"

I'm interested in this issue. I noticed the Hyperlink data type
definitely does not respond like a string data type would.

Personally I would have only stored the relative path, but that's
water under the bridge right now.

-Tom.
Microsoft Access MVP

 

[Lars Brownies]

I found a way to do the Find & Replace:
1. Change the Hyperlink datatype to Memo (Text datatype is not long enough)
2. Do the Find & Replace action (search in part of the field)
3. Change the datatype back to Hyperlink

Lars