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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Generate a new backend 2
Referential Integrity for Lookup fields in tables 7
Referential Integrity Problem 4
Tables and Relationships Help! 3
database splitter 3
Referential Integrity Unavailable 2
Enforce referential integrity when to use in relationship? 2
Joins & Cascading 4

Back
Top