View Full Version : Referential Integrity and linked tables


Bogzla
07-07-2006, 09:09 AM
Just a quick question, it appears that I can't Enforce RI for relationships where one of the tables is linked from another *.mdb (the checkbox is greyed out)... is this a general thing with linked tables?

Thanks,
Bogzla

Banana
07-07-2006, 09:16 AM
RI is done from the backend. You'd go and open the back end to fix it up. Access will follow the RI set in backend even if front end has none.

Pat Hartman
07-17-2006, 07:25 PM
Both tables you want to relate MUST be in the same database.