Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post
    I need to change the ODBC Connection String of all of the pass through queries in a database.

    Pass Throught queries do not seem to be a part of the querydefs collection.

    How do I address pass through queries in code so that I can modify the connection string?

    Version Access 97, yep 97!

  2. #2
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post
    Don't know how I missed it the first time but they are in the querydefs collection and the connect property can be modified.

Posting Permissions

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