Creating Relationship with Linked Table

[Guest]

I have an Access table that is linked to an ODBC database. I am trying to
create a one-to-many relationship between this table and two other tables in
the same Access db that are not linked. I've noticed that the check box to
enforce referential integrity or cascade update is not available while
creating the relationships. Is there a way to enforce referential integrity
in this situation?
Thank You,
Jason

 

[Marshall Barton]

I have an Access table that is linked to an ODBC database. I am trying to
create a one-to-many relationship between this table and two other tables in
the same Access db that are not linked. I've noticed that the check box to
enforce referential integrity or cascade update is not available while
creating the relationships. Is there a way to enforce referential integrity
in this situation?

No. The database engine that manages the data is
responsible for referential integerity. A front end is only
asking the backend db engine to retrieve the data so there
is no way it can be sure that referential integrity is
properly maintained.

 

[Guest]

Ok then - thanks for the info.

No. The database engine that manages the data is
responsible for referential integerity. A front end is only
asking the backend db engine to retrieve the data so there
is no way it can be sure that referential integrity is
properly maintained.

 

[Bas Cost Budde]

It is unlikely that you let your users edit straight into the table,
though. And when using a form, there is more at your disposal.
You can use various events on the form and write your own 'referential
integrity' code to enforce it, as long as the user uses the form.