Access97 "Database Splitter Add-In" Loses Table Relationships

  • Thread starter Thread starter Sandy Eastman
  • Start date Start date
S

Sandy Eastman

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
 
Sandy Eastman said:
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,
Click to expand...

Yes, any relationships in the front end are for documentation purposes only. The
back end is what matters.
 
Back
Top