Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...
MS Access Forum / General 1 / September 2004

Tip: Looking for answers? Try searching our database.

Query Grid no longer shoes relationships

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve O. - 02 Sep 2004 18:57 GMT
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.
Reply to this Message
Rick Brandt - 02 Sep 2004 20:40 GMT
> HI,
>
[quoted text clipped - 7 lines]
> The stored relationships are, btw, displayed correctly when adding
> tables to the grid in the backend database.

Tools - Options - Tables/Queries - Enable AutoJoin

Signature

I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

Reply to this Message
Steve O. - 02 Sep 2004 21:05 GMT
>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.
Reply to this Message
Larry  Linson - 02 Sep 2004 21:33 GMT
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

> >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.
Reply to this Message
Steve O. - 02 Sep 2004 22:16 GMT
>Do you have relationships defined in the back-end?

yes, absolutely.
Reply to this Message
Rick Brandt - 02 Sep 2004 21:51 GMT
> >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.

Signature

I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

Reply to this Message
Steve O. - 02 Sep 2004 22:28 GMT
>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.
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.