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

[DALE CHIACCHIO]

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

Thank you

 

[Jeff Boyce]

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

 

[Douglas J. Steele]

It's not possible, at least, not in Jet databases (MDB or ACCDB files)

 

[Sylvain Lafontaine]

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)