Looking for a query to update document locations linked in a table 1

[breezett93]

Every record in this table has a link that opens up a document about the record. The location for many of them has been changed; so I need to update the link in the table. All the links that need to updated have the same starting directory.

Here's what I'd like to do:

Example of a record link: \\server\Oldfolder\folder\document.pdf

While Not EOF
If field contains "\\server\Oldfolder" Then
Replace with "\\server\Newfolder" without overwriting the remaining part of the link

I could probably come up with an inefficient solution, but I was hoping someone that did this before had a good solution.


Thanks!

 

[Andrzejek]

How about:

Update TableA
Set LinkField = Replace(LinkField, "\\server\Oldfolder", "\\server\Newfolder")
Where LinkField LIKE "\\server\Oldfolder*"


---- Andy

There is a great need for a sarcasm font.

 

[breezett93]

Fantastic! It worked. Thank you.

 

[dhookom]

breeezett93,

If it's "fantastic" you need to click the "Great Post!" link to mark the question as answered and give some credit to Andy.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016