linking tables in separate databases

L

Lindsey

Is it possible to join tables from separate databases
together in a relationship, i.e, to connect by a primary
key ID? If yes, how??
 
J

John Vinson

Is it possible to join tables from separate databases
together in a relationship, i.e, to connect by a primary
key ID? If yes, how??
Click to expand...

No; you can create a Query linking tables which reside in separate
databases, but you cannot create a relationship (since neither
database has any way of enforcing that relationship).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search in multiple databases/tables 3
relationship between 2 databases 4
Two databases or one 4
Merging Two databases into one 4
referential integrity and tables 4
same field in more than one table 2
Relationship 2
Redesign of an old Access Database with Linked Tables 4

Top