Query Across Two Databases

  • Thread starter Thread starter GrahamC
  • Start date Start date
G

GrahamC

I cannot figure out how to create an updateable query
using tables in two, or more, ACC2000 databases.

For example, create the ProjectMarket query from:

1: ProjectName in Projects table in Active database
2: ProductName in Products table in Business database
3: MarketName in Markets table in Business database

where the Projects table contains a ProductName field,
the Products table contains a MarketName field.

The resulting query will contain ProjectName, its parent
ProductName, and its parent MarketName.

Thanks.
 
Can you link the needed tables from the other database?


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Steve:

Thanks for the reply ...

Both databases reside in the same directory of a website.
The pages of the website use server-side scripting, ASP,
IIS.

Any SQL that gets written has to also work with SQL Server
and Oracle.

Thanks.
 
Will this work?

select proj.ProjectName, prod.ProductName, mark.MarketName
from Active.Project proj, Business.Product prod, Business.Market mark
where prod.ProductName = proj.ProductName
and mark.MarketName=prod.MarketName

Fay
 
Back
Top