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

Query Grid no longer shoes relationships

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
"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
Nov 13 '05 #2

P: n/a
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.

Nov 13 '05 #3

P: n/a
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.

Nov 13 '05 #4

P: n/a
"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
Nov 13 '05 #5

P: n/a
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.

Nov 13 '05 #6

P: n/a
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.
Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.