Changing Paths for Hyperlinks in Access Table

[bertrandr]

Hi,

I am planning to insert links on a table to wordperfect documents, pdf files, folders, etc. on our server. Before we begin the linking process I wanted to know ahead of time what would happen if in the future we were to move all the documents to a new drive or new location on the server. Is there a way to easily redirect links from one drive to another.

Thanks,

Linda

 

[HitechUser]

bertrandr,

Assuming you are storing the links in a text field, all you will need to do is create an update query that replaces the server and path portions using standard string functions.

Here is a post. Look at PHV reply. Just change from a Select query to an update query.

http://www.tek-tips.com/viewthread.cfm?qid=952372

Also there are other examples, just search this site.

I hope this helps.

 

[PHV]

Another thread of interest for you:

http://www.tek-tips.com/viewthread.cfm?qid=941929

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[bertrandr]

I thought I searched the forum for this topic. . . Thanks for the informative advice and threads. I haven't tried to do it yet but will do so soon.

Linda