Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004

    Exclamation Unanswered: Urgent: Connecting to Access and Sql Database

    Hiiiii everyone,

    Hope that i could find my solution here.

    i'm working on an asp page and i need to display data from 2 different databases one is in sql server and the other is in access

    currently i have linked the sql tables into the access database but problems occur where i have to refresh the tables regulary

    so what i need is to be able to select from the sql and access seperatly in one select statment

    How could i create the connections for both of them to be able to do so??!!

  2. #2
    Join Date
    Nov 2003
    Christchurch, New Zealand
    Apart from linking as you said I really can't think of a way you could do it, not with one select statement.

  3. #3
    Join Date
    Sep 2004
    Thanks anyways,
    i kept as it is linked, its seems that its working fine now


Posting Permissions

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