Hypertext link at wrong address

[Yvesm@aei.ca]

I had to replace my HD and with a new address to my Access Base.
I have 30,000 records in the table and 4 fields in each of them who must directly open a Pdf file for each or Html for some on the Web.
I did change the name on the fields of each records to new name (witch is the Address to follow) with VBA (SQLString = Update ..... ) but the link is still on the old Address
How can I replace the HyperlinkPart([Field], 0) value for HyperlinkPart([Field], 2) Value
I did try a lot of way without any success


30,000 fields X 4 fields is to long for an answer, I can use VBA to do so
Thanks
Yves

[June7]

What was the exact SQL statement? A Replace() operation should work.

UPDATE tablename SET fieldname = Replace(fieldname, 'oldpath', 'newpath')

Post your procedure code.

I NEVER use Hyperlink type field.

[Yvesm@aei.ca]

sqlstring = "UPDATE plus10000 SET plus10000.[Lien Ordi1] = Right([plus10000]![Lien Ordi],Len([plus10000]![Lien Ordi])-12);"
DoCmd.RunSQL sqlstring


vnom = "C:/users/yvesm"
sqlstring2 = "UPDATE plus10000 SET plus10000.[LienPrinc] ='"
sqlstring2 = sqlstring2 + vnom
sqlstring2 = sqlstring2 + "' + ([plus10000]![Lien Ordi1])"
DoCmd

Thanks

[June7]

Did you try Replace() as suggested?

What do you mean by "did change the name on the fields of each record"? What field - the Hyperlink field?