Pass through query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On a pass-through query to SQL server 2k, is there any way to link to tables from two different databases? Within the query, I need a couple of tables from one database, and a couple from another.
Thanks so much for the help and have a great holiday today!
 
Use 3 part naming:

databasename.dbo.tablename

HTH


smk23 said:
On a pass-through query to SQL server 2k, is there any way to link to
Click to expand...
tables from two different databases? Within the query, I need a couple of
tables from one database, and a couple from another.
 
that won't help me because the DSN is pointing to a single database. I am pretty sure the answer is no, I can't use tables from two different DBs.
 
Did you try Newbie's suggestion?

--
Duane Hookom
MS Access MVP


smk23 said:
that won't help me because the DSN is pointing to a single database. I am
Click to expand...
pretty sure the answer is no, I can't use tables from two different DBs.
 
okay, okay, you guys are right! And I am surprised. But thanks a lot because this changes a lot of things!
 
Back
Top