Batch change hyperlinks to images

[amer]

I have a Hyperlink question. I have a image on each sheet in my database. The image is stored in a folder on a separate computer and it is viewed with a hyper link.



I want to move the images to a new computer so the hyper link needs to be changed. The problem is I have 1800 items and I really don't want to do it one by one. Is there a way to change the hyperlink for all the records at the same time pointing to the new location?

Thank you in advance. I'm totally new to Access and just took this database over. So I'm not the creator of it and don't know that much about.

Amer

[amer]

Ok I tried to use find and replace. It work but with one small problem. It only changed the text that appears under the image and not the actual hyperlink.

When I view the database in the datasheet view the actual hyperlink for the image that is displayed is not there.

Where can I find a list of the hyperlinks for all of the records in the database.

[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/h...rlink-282.html

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