var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Urgent: Connecting to Access and Sql Database
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??!!
Apart from linking as you said I really can't think of a way you could do it, not with one select statement.
i kept as it is linked, its seems that its working fine now