where to keep the table relationships in a split database

[Paul James]

After you split an mdb file into a back end file that contains the tables,
and a front end that contains everything else, where do you put the table
relationships?

- in the front end?
- the back end?
- or both?

Thanks in advance.

Paul

 

[Rick Brandt]

After you split an mdb file into a back end file that contains the tables,
and a front end that contains everything else, where do you put the table
relationships?

- in the front end?
- the back end?
- or both?

The back end. In fact for relationships where you need to enforce referential
integrity you can only do this in the back end. Any relationships you create in
the front end are more of a window dressing or a way to document the
relationships between the tables, but they don't enforce anything.

 

[Paul James]

Thanks for the info, Rick.

I wasn't sure because I've noticed that when you use the Database Splitter
from the Database Utilities Menu to split the database, both the front end
and back end retain the preexisting relationships. But then it occurred to
me that there could be an inconsistency if you changed the relationships in
one mdb file but not the other. So I figured that only one would actually
define the relationships.

Thanks for explaining that it's the back end that determines the
relationships.

Paul