By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Relationships not showing again

P: n/a
Sorry to re-post this question but still having problems with relationships
I am running duplicate databases on 2 machines, Ak2 SP3 and windows XP SP2.
I hace 2 databases both with FE & BEs. I can freely copy them between the 2
machines, both FE & BE

On my home machine the relationships are normal, but on the office machine
if I look at the relationships in the FE database, all the tables are there,
but non of the linking lines. Equally with queries in DesignView, the
joining lines can be seen, but as thin lines, not the normal thick ended
line with "1" at one end and "?" at the other. It appears that the enforcing
referential integrety is working.
I have updated drivers, re-installed office, and can find nothing wrong. Is
it likely to be something in the Registry.

Thanks for any further advice

Phil
Aug 19 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I don't think I would worry too much about seeing relationships in the
FE. They only count in the BE. If you can't see the relationships in
the BE - then you have something to worry about. I also would not try
to establish relationships between tables in the FE and on the BE. It
can be done, but not a good practice. If you need to have referential
integrity locally - I would import/copy data from the BE/Linked tables
to local tables and do your referential integrity locally.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Aug 19 '08 #2

P: n/a
Thanks for coming back, Rich

Both FE & BE are on the same computer, so your bit about local tables seems
redudant. Just curious and more than a bit concerned about being able to see
the relationships on one computer and not the other

Cheers

Phil

"Rich P" <rp*****@aol.comwrote in message
news:12*************@news.newsfeeds.com...
>I don't think I would worry too much about seeing relationships in the
FE. They only count in the BE. If you can't see the relationships in
the BE - then you have something to worry about. I also would not try
to establish relationships between tables in the FE and on the BE. It
can be done, but not a good practice. If you need to have referential
integrity locally - I would import/copy data from the BE/Linked tables
to local tables and do your referential integrity locally.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

Aug 19 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.