How do I setup up an Access table relationship between databases?

  • Thread starter Thread starter DALE CHIACCHIO
  • Start date Start date
D

DALE CHIACCHIO

I am trying to setup a relationship with between tables in different
databases? Is this possible?

Thank you
 
Conceptually, that has some problems. What if someone used DB2 and entered
some data without realizing that DB1 has a related table? If you want to
establish and enforce a relationship between DBs, I believe you'll have to
write code and put it in BOTH DBs.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
It's not possible. However, this doesn't forbid you to join tables from
different databases in your SELECT queries. Unless you wanted to set up a
relationship with Cascade Delete or Cascade Update; you lose nothing by not
etablishing any explicit relationship but don't forget to etablish the
proper indexes on the foreign keys fields for performance reason.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)
 
Back
Top