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