relationships when using 2 mdbs

  • Thread starter Thread starter leah f via AccessMonster.com
  • Start date Start date
L

leah f via AccessMonster.com

I have an mdb that links to tables in another mdb. Relationships are
defined in both places and they are not the same.

When running the program which does it follow? Can I delete all
relationships of the mdb with the definition of forms/queries...?
 
You can only enforce referential integrity on relationships defined between
tables in the same database. Any relationships between tables in different
databases can not be enforced.
 
I have only one database but two mdbs. One mdb (call it mdb1) has all the
forms,queries etc. The other one (mdb2) has all the tables. In mdb1 I
linked all the tables in mdb2.

I defined all the relationships in mdb2 but I now see that relationships
are also defined (but different) in mdb1. I don't know which one it is
using.
 
Only the relationships in mdb1 (the one that contains the tables) can be
enforced. The relationships in mdb2 (the one that contains the links) *may*
be used to draw default joins in queries (I can't say for sure, because I've
never drawn relationships between links) but can not be used to enforce
referential integrity.

Referential integrity can only be enforced on relationships that exist in
the database that contains the tables.
 
Back
Top