Referential Integrity Mystery

[Richard Harison]

I have a split database. back-end is only 3 related table (standard
many-to-many). Referential Integrity was set up with both cascades. Now Access
has somehow decided to gray out the ref int/cascades when I check on the
relationship. I did import a query but the design window shows the links
intact. Additionally, in a separate instance, I copied 2 tables, (structure
only) and replaced the tables I had used with dummy data. Same thing. The
back-end tables show the ref int + cascades OK. Could this just be when I look
at the relationships from the front end table?
Anyone tell me what's going on?

 

[Brendan Reynolds]

If you're looking at the relationships in the 'front end' application MDB,
then this is perfectly normal. Those options are disabled in that MDB
because you can only edit them in the 'back end' data MDB where the tables
are stored.

 

[Richard Harison]

O thank you Brendan!
How sweet it is when the answer is sooo simple! Guess I spent too much time
behind the keyboard today. I sort of suspected that, but in importing tables,
queries & reports, and trying to put that all together, I guess I panicked! I
should have been comforted by the bold black lines and the 1 to infinity symbols
which I saw but did not appreciate at the time! Much thanks!!

--
All the Best
Richard Harison

If you're looking at the relationships in the 'front end' application MDB,
then this is perfectly normal. Those options are disabled in that MDB because
you can only edit them in the 'back end' data MDB where the tables are stored.