Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unhappy Unanswered: View for updating Hyperlinks

    I have a database that has SQL 2000 as the engine and Access 2003 on the front end, we scan our documents and hyperlink them through Access, the address is stored in SQL Server but we are wanting to move SQL, the scanned documents along witht he ADP over to a different server so instead of the files linking to \\gcfso1 they will link to \\gcfsql. is there a way to update the address link in SqL to link to \\gcfsql as an update view rather then relinking them by hand????

    Help

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    You could create a view with the replace function applied to the URL. See BOL for the details.

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Hmm

    ok how about a stored procedure that will change

    Scanned Report#\\gcfs01\DataBase\Reports\Incident Reports\IR's 2001\01

    to: Scanned Report#\\gcfsql01\DataBase\Reports\Incident Reports\IR's 2001\01-1108.pdf#


    I'm not quite sure how to do an update like that?? can you give me an example or something

  4. #4
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Talking sorry

    can you give me an example please

Posting Permissions

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