Query Grid no longer shoes relationships

[Steve O.]

HI,

(Access 97) The query grid has lost the ability to recognize or "pick
up" the relationships that exist between the tables. I have to
manually connect the tables in the grid. Then upon saving, closing
and reopening, the correct 1-to-many, etc symbols appear. I tried
repairing the database and refreshing the links to the backend
database (also Access 97). No change.

The stored relationships are, btw, displayed correctly when adding
tables to the grid in the backend database.

[Rick Brandt]

"Steve O." <a@b.c> wrote in message
news:f5********************************@4ax.com...

HI,

(Access 97) The query grid has lost the ability to recognize or "pick
up" the relationships that exist between the tables. I have to
manually connect the tables in the grid. Then upon saving, closing
and reopening, the correct 1-to-many, etc symbols appear. I tried
repairing the database and refreshing the links to the backend
database (also Access 97). No change.

The stored relationships are, btw, displayed correctly when adding
tables to the grid in the backend database.

Tools - Options - Tables/Queries - Enable AutoJoin
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Steve O.]

On Thu, 2 Sep 2004 14:40:20 -0500, "Rick Brandt"
<ri*********@hotmail.com> wrote:

Tools - Options - Tables/Queries - Enable AutoJoin

Yes, I tried unchecking it and checking it again to see if ot would
somehow "recapture" the relationships, no dice. Sorry, I forgot to
mention that in my post.

[Larry Linson]

Do you have relationships defined in the back-end? They might have gotten
lost in the split, and to be useful, they have to be in the database where
the data resides.

Larry Linson
Microsoft Access MVP

"Steve O." <a@b.c> wrote in message
news:16********************************@4ax.com...

On Thu, 2 Sep 2004 14:40:20 -0500, "Rick Brandt"
<ri*********@hotmail.com> wrote:

Tools - Options - Tables/Queries - Enable AutoJoin

Yes, I tried unchecking it and checking it again to see if ot would
somehow "recapture" the relationships, no dice. Sorry, I forgot to
mention that in my post.

[Rick Brandt]

"Steve O." <a@b.c> wrote in message
news:16********************************@4ax.com...

On Thu, 2 Sep 2004 14:40:20 -0500, "Rick Brandt"
<ri*********@hotmail.com> wrote:

Tools - Options - Tables/Queries - Enable AutoJoin

Yes, I tried unchecking it and checking it again to see if ot would
somehow "recapture" the relationships, no dice. Sorry, I forgot to
mention that in my post.

Once enabled it will only have an affect on NEW queries that you create.
Did you try that? It won't insert lines on Queries already saved.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Steve O.]

On Thu, 02 Sep 2004 20:33:36 GMT, "Larry Linson"
<bo*****@localhost.not> wrote:

Do you have relationships defined in the back-end?

yes, absolutely.

[Steve O.]

On Thu, 2 Sep 2004 15:51:08 -0500, "Rick Brandt"
<ri*********@hotmail.com> wrote:

Once enabled it will only have an affect on NEW queries that you create.
Did you try that?

Yes I did.

I've also tried to repair both databases. No Dice.

I also linked the tables from the backend into a blank database- same
problem.

I converted the databases to 2003, now it works fine again (not an
option right now though).

I created dummy front end and back end databases (97) with
relationships defined in the backend, then linked into the front end -
again the grid works just fine. So it appears to be something to do
withe the backend mdb file, but I'm not sure what.