Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    9

    Unanswered: Mass Updating hyperlinks

    We recently changed servers. Previously I used an Access database that referenced contracts that are stored as .pdf files and could be clicked on and brought up using hyperlinks. Now that we've changed servers the beginning of the path to where these .pdf files are stored has changed. Is there an easy way to mass change the beginning of the hyperlinks to this new path without manually going into each hyperlink and deleting/typing the new path? I'm somewhat of a novice but any help would be appreciated. My carpal tunnel problem can't take the repetition!!!

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    You could use an UPDATE query with the Replace function:

    UPDATE TableName
    SET FieldName = Replace(FieldName, "OldServerName", "NewServerName")
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •