Relationships and Split Databases

[Guest]

I have a sales order database which I recently split. I have put the tables
on the server and a copy of the application on each work station that needs
it.

I now have an apparent problem in that all the relationships between tables
seem to have been deleted. In fact the relationships window for the BE shows
neither relationships nor tables. It is causing some problems although they
appaer to be minor at the moment e.g. deleting records in one table does not
delete related records in other tables. It raises a couple of questions.

1. Does this normally happen when a database is split?
2. If so why does it happen
3. Is fixing the problem simply a matter of re-establishing the relationships
4. Am I correct in thinking the relationships should be set in the BE
relationships window.

All help is greatly appreciated

Cheers

 

[Albert D. Kallal]

1. Does this normally happen when a database is split?

Not really. Remember, if you hit the "delete" button when in the relations
window to remove a table, the relationship remains in tact.

So, your relationships are likely still there...just not shown.

2. If so why does it happen

As mentioned, there not removed, nor are your relationships deleted. Open up
the back end, and simply go add tables...as you drop back in the
tables...you see the connections and relationships are still there.

3. Is fixing the problem simply a matter of re-establishing the
relationships

They should be there already. Splitting DOES NOT delete, remove, or change
the relationships.

4. Am I correct in thinking the relationships should be set in the BE
relationships window.

Yes, you 100% on this...

You set the relationships were the tables are. So, if have some tables in
the front end that need relationships, then you set them in the front end.
However, most tables will be in the back end, and that were you set the
relationships (think if two front ends with different relationships opened
the data file...which one would rule -- so, it were the tables actually are
you set this).

 

[Tony Toews [MVP]]

As mentioned, there not removed, nor are your relationships deleted. Open up
the back end, and simply go add tables...as you drop back in the
tables...you see the connections and relationships are still there.

Or just hit the Show All Relationships button on the toolbar.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

I now have an apparent problem in that all the relationships between tables
seem to have been deleted. In fact the relationships window for the BE shows
neither relationships nor tables. It is causing some problems although they
appaer to be minor at the moment e.g. deleting records in one table does not
delete related records in other tables. It raises a couple of questions.

1. Does this normally happen when a database is split?
2. If so why does it happen
3. Is fixing the problem simply a matter of re-establishing the relationships
4. Am I correct in thinking the relationships should be set in the BE
relationships window.

To add to Albert's reply you can copy the layout of the relationships
window from your unsplit database.

Use the sysrels utility at the following location to copy the table
relationships layout window
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=12#12
Or use Save Restore Modify Relationship Window at
http://www.lebans.com/saverelationshipview.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/