Combining two mdb files

[Mike_T]

Hi,

Is there a way to create a query from two mdb files? If so, how?

TIA

Mike

 

[Michel Walsh]

Hi,


Sure, link the tables from the second db into the first one. To link tables,
use the Menu: File | Get External Data...

One of the things you cannot do is to define referential data integrity
between a native table and a linked table, but you can use a linked table
inside a query.

Hoping it may help,
Vanderghast, Access MVP

 

[John Vinson]

Hi,

Is there a way to create a query from two mdb files? If so, how?

TIA

Mike

You can use File... Get External Data... Link to link a table from one
database to another database, and create a query joining the linked
table to a local table.

John W. Vinson[MVP]

 

[Jamie Collins]

Sure, link the tables from the second db into the first one.

Another approach is to embedded the connection string to the external
data source in the query e.g.

SELECT col1
FROM Test
UNION ALL
SELECT data_col AS col1
FROM [MS Access;DATABASE=C:\Newt.mdb;].Test

One of the things you cannot do is to define referential data integrity
between a native table and a linked table

Another is to use them in CHECK constraints

Jamie.

--