Access97 "Database Splitter Add-In" Loses Table Relationships

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
 
R

Rick Brandt

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

Referential Integrity Unavailable 2
fe and be problems with deletion and relationships 7
no table relationships defined 1
Creating Relationship with Linked Table 3
Database splitter destroys all table relationships. Why? 7
Relationship After Splitting DBA 2
Cascade Delete and Update Issue 4
Make table query and Table Relationships (Notify Me) 2

Top