database

[gandy]

is it possible to query two tables in different .mdb files in a similar fashion as when i query two tables in the same .mdb file

select * from table1 where field1 = field
UNIO
Select * from table2 where field1 = field

This is basically how i join tables in the same database. Is there something similar that will join two tables in different databases

 

[Fred]

give this a try..

In the first MDB create an external link to the other table in the other MDB
then code you query in the first MDB.

Fred

is it possible to query two tables in different .mdb files in a similar

fashion as when i query two tables in the same .mdb file?

select * from table1 where field1 = field1
UNION
Select * from table2 where field1 = field1

This is basically how i join tables in the same database. Is there

something similar that will join two tables in different databases?

 

[gandy]

what is an external link and how do i create one between two databases or .mdb files

 

[gandy]

I think i know what you mea

First link the tables in Access

then create the query in frontpage