relationships when using 2 mdbs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

leah f - 19 Apr 2005 06:18 GMT

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...?

Reply to this Message

Brendan Reynolds - 19 Apr 2005 12:17 GMT

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.

Signature

Brendan Reynolds (MVP)

>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...?

Reply to this Message

leah f - 19 Apr 2005 12:28 GMT

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.

Reply to this Message

Brendan Reynolds - 19 Apr 2005 19:11 GMT

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.

Signature

Brendan Reynolds (MVP)

>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
[quoted text clipped - 3 lines]
> are also defined (but different) in mdb1. I don't know which one it is
> using.

Reply to this Message