Relationships and Split Databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
1. Does this normally happen when a database is split?
Click to expand...

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
Click to expand...

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
Click to expand...

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.
Click to expand...

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).
 
Albert D. Kallal said:
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.
Click to expand...

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/
 
paulu said:
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.
Click to expand...

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/
 
Back
Top