Query Across Two Databases

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.
 
M

[MVP] S.Clark

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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
G

Guest

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.
 
F

Fay

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
 
Top