Change image directory

[amer]

I need to change the image directory for my whole database.



Example:

J:\documents\my images

I need to change it to

R:\documents\my images

I moved the images to a new computer and all my hyperlinks no longer work.

Is there anything I can do.....

Thanks

[NTC]

yes, but it is a little complicated ; you will want to research the hyperlink field type and the hyperlink method in Help (both VBA help and Access help)....also google it on this topic to see the Q&As on this topic.

you will need to run an update query to change all those hyperlink values. the tricky thing about hyperlink is that what you see isn't what you change...hyperlink fields are multipart - and you don't change the part you see....

if there were only a few - you could simply manually relink them...but if there is alot then you need to set up this one time update query and change them en masse. I have done it, it works...but has been a couple years so I don't have all the details at my finger tips....

[amer]

Yes what you see is only the text field and I was able to change that with the replace command but as you said that's not the actual link. So the database is still looking for the images in the old directory.

I have just over 1800 records so the last thing I want to do is a manual one by one change of the links..... That would be a nightmare.

It looks like I need to look into the change query.

[amer]

Thanks to Suzan I was able to get this done. It was actually easy once I new what to do. As the JOE's say " knowing is half the battle"

I selected my table.

Selected my field.

Changed the data type from hyperlink to text. ( this showed me all the actual hyperlinks)

Then I used the replace command to change the directory in the hyperlinks from J:\ to R:\

Finally I changed the data type from text back to hyperlink and it worked perfect.

Here is a link to the actual thread that lead me to this.

https://www.accessforums.net/forms/ho...rlink-282.html

Hope this can help someone else down the line.....