Relationships in Split database

[יריב החביב]

Hello,

I know, from previous experience, that when the Relationships between the
table's are characterize in the back database, they are outomaticlly get the
same
characterization when we add them to the Relationships board in the front
database.

What can be the reasone that it is not happned ?

thank you

 

[Allen Browne]

As you say, the relationships that exist in the back end should be displayed
in the Relationships diagram in the front end.

If this is not happening, you might try some of these ideas:

1. In relationships view in the front end, click the Show All button.

2. Make sure Name AutoCorrect is turned off in the back end, and then
compact/repair it. Then do the same in the front end. If you need details,
it's the first 3 steps explained here:
http://allenbrowne.com/recover.html

3. If you are still stuck at this point, delete the attached tables from the
front end, and link the tables again. To link the tables, use the External
Data tab of the ribbon in A2007, or Get External on the File menu in
previous versions.

 

[יריב החביב]

paragraph 3' fix it, thank you.

 

[Tony Toews [MVP]]

I know, from previous experience, that when the Relationships between the
table's are characterize in the back database, they are outomaticlly get the
same
characterization when we add them to the Relationships board in the front
database.

I never use the relationships window while in the FE. Just the one in
the BE. Besides the one in the BE is formatted nicely to my
preferences.

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/