@seastmannospam: "Access97 "Database Splitter Add-In" Loses Table Relationships
When you split a database, neither the FrontEnd or BackEnd keeps the join
relationships of the tables.
In other words you lose "Enforce Referential Integrity", "Cascade Update"
and "Cascade Delete".
The FrontEnd allows you to make joins, but the enforce and cascade boxes are
greyed out and unavailable, so...Should I just put all the table
relationships back into the BackEnd?
Regards,
   Sandy Eastman"
    @rickbrandt2: "news:<email_address>
<quote>
Yes,  any relationships in the front end are for documentation purposes only.  The
back end is what matters."
{'source': 'USENET', 'other_information': '{"reply_count": 1, "forum_name": "microsoft.public.access.gettingstarted.20140624.mbox"}', 'file': 'data/output/usenet-microsoft.public.parquet'}