Combining two mdb files

  • Thread starter Thread starter Mike_T
  • Start date Start date
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
 
Hi,

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

TIA

Mike
Click to expand...

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]
 
Michel said:
Sure, link the tables from the second db into the first one.
Click to expand...

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
Click to expand...

Another is to use them in CHECK constraints :(

Jamie.

--
 
Back
Top