Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005

    Unanswered: Change ODBC string for linked sprocs

    I have a bunch of queries linked to SQL Server 2005. I was wondering if anyone knows a way to change all the ODBC connections string for the linked queries. I also have linked tables and can use the linked table manger to change all of them. Is there anything like that for linked queries?

    I have recently got myself a DEV and QA enviroment to work in and need easy ways to publish access projects to each enviornment.

    Thanks in advance.

  2. #2
    Join Date
    Dec 2004
    Madison, WI

    ODBC create/update linked tables

    Maybe this will help. It automatically updates/creates DSN's.
    Attached Files Attached Files
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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