Urgent: Connecting to Access and Sql Database

Help Seeker · #1 (**permalink**) 09-23-04, 03:54

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??!!