Creating a relationship with a linked table

[scubadiver]

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.

 

[Allen Browne]

Correct: Access cannot enforce a relation across different files.

 

[John W. Vinson]

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.

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]

 

[scubadiver]

duhhh! It does make perfect sense!

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]