Query Map

[Matt Greatorex]

Is there an automatic way, within Access, to see all of the relationships between various queries?

I've inherited a db with no documentation and many interrelated queries.

I'm about to start 'mapping' it by hand, but was hoping to make my life easier.

 

[namliam]

While in the database window, in the main menu:

Tools => Relationships

IF that has been used...

 

[Matt Greatorex]

Thanks for the response.
If only it were that simple. Unfortunately, no relationships have been declared in this way.

 

[KeithG]

Try the below SQL. It will give the query name and all relationships in the query.

SELECT DISTINCTROW MSysObjects.Name, MSysQueries.Expression AS Relationship
FROM MSysObjects INNER JOIN MSysQueries ON MSysObjects.Id = MSysQueries.ObjectId
WHERE (((MSysQueries.Attribute)=7));

 

[Matt Greatorex]

I think that's exactly what I'm looking for.

Thanks a bunch - you've saved me a lot of query-by-query manual checking.