Relationship After Splitting DBA

[Toan Chau]

Hello.

I recently used the database split wizard. It split all
my tables into a backend with all else in the front end.

When I use the frontEnd after the database split I don't
have the option to "Enforce Referential Integrity" anymore
in the table relationships. Is there a reason for that?

Thanks,
-Toan

 

[Douglas J. Steele]

The relationships are in the back-end, not the front-end. That's the way it
should be, because then the RI will be enforced even if you're updating the
database by some other means than your front-end.

 

[Toan Chau]

Thanks for clearing it up for me!
-Toan

-----Original Message-----
The relationships are in the back-end, not the front-end. That's the way it
should be, because then the RI will be enforced even if you're updating the
database by some other means than your front-end.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)






.