Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post May 02, 2012 08:59 AM by dotnetpree
May 01, 2012 04:35 PM|LINK
How do i query into multiple database and return results based on SSN? I am using visual studio and i have connection string for SQL and Access in webconfig.
Database Name: User data.mdb
Database name: sql2.UserTracking.dbo
field: FIRST NAME
May 01, 2012 04:47 PM|LINK
Set up linked tables to the sql db in your access db.
May 02, 2012 08:59 AM|LINK
from User data.dbo.UserInformation as t1
sql2.UserTracking.dbo.User_Info as t2
on t1.SSN = t2.SSNO