Replacing a hyperlink

[scuttleButt]

I am very new to Access 2000. I usually work with SQL Server. I have a database that I adopted. One of the fields called "link" is a hyperlink field. I want to globally replace all of the links from one thing to another. example replace: \\datawashere - to: \\dataishere\now. I tried to use the find and replace (replace tab -> look in = link -> match = any part of string) button on the tool bar but it doesn't find \\datawashere... any suggestions?

 

[mwolf00]

Try to see if you can select them w/ this...

SELECT link FROM myTable WHERE LEFT(link,len('\\datawashere')) = '\\datawashere'

An UPDATE might work like this:

UPDATE myTable SET link = '\\dataishere' + right(link,(len(link) - len('\\datawashere') WHERE LEFT(link,len('\\datawashere')) = '\\datawashere'
-- What did you expect? This is FREE advice. LOL