changing drive letter on file path

[jamym42]

I have thousands of pictures on an external hard drive that I've linked to Access so that each form displays a different picture. My problem is that the pictures will only display if I have the hard drive plugged into the right drive (so that the filepath is correct).

Is there a way that I can change just the drive letter on many filepaths simultaneously in Access?

Thanks!

 

[boblarson]

You could use an update query along with the Replace function.

 

[jamym42]

How do I do that so I just replace the first letter?

 

[boblarson]

UPDATE TableNameHere SET FieldNameHere = Replace(FieldNameHere, "C:\", "D:\")

I used C or D as just an example and be sure to replace with your actual field/table name.