Creating a relationship with a linked table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my database three of my tables are linked from another database and I want
to create a relationship with one of these tables but it won't let me.

cheers.
 
In my database three of my tables are linked from another database and I want
to create a relationship with one of these tables but it won't let me.

cheers.
Click to expand...

It can't.

Think about it: suppose you define a relationship, referential integrity
enforced, in A.MDB enforcing a relationship between a table in A with a table
in B.MDB.

I come along, open B.MDB, open the related table, and start editing data.

A.MDB isn't even OPEN and has no way to keep me from violating the
relationship rules.

John W. Vinson [MVP]
 
duhhh! It does make perfect sense!


John W. Vinson said:
It can't.

Think about it: suppose you define a relationship, referential integrity
enforced, in A.MDB enforcing a relationship between a table in A with a table
in B.MDB.

I come along, open B.MDB, open the related table, and start editing data.

A.MDB isn't even OPEN and has no way to keep me from violating the
relationship rules.

John W. Vinson [MVP]
Click to expand...
 
Back
Top