Results 1 to 8 of 8
  1. #1
    Nanuaraq is offline Advanced Beginner
    Windows 7 32bit Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    77

    Seeing how queries "relate" to each other

    I have a complicated query, where I must first create queries of a lot of different items, calculate some results, and then create more queries that gather their information from some of the earlier queries.


    It works well (I must say, Access is very flexible on that point), but I lack an overview.

    I would like something very muc akin to the visual overview of relations between tables that Access provides, only I would like it to be an overview of what queries feed information into what other queries.

    Is there something Access can do for me to that aim?

    Thank you in advance.

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Select a query, go to Database Tools, then Object Dependencies.
    You may also find the Database Documenter useful though possibly TMI.
    Try it first with the minimum options available an go from there.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    Robyn_P's Avatar
    Robyn_P is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Nov 2017
    Posts
    150
    This is great. I've been drawing and updating Viso diagrams as I've gone along. Did not know about the object dependencies. Much better!

  4. #4
    Nanuaraq is offline Advanced Beginner
    Windows 7 32bit Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    77
    Quote Originally Posted by ridders52 View Post
    Select a query, go to Database Tools, then Object Dependencies.
    You may also find the Database Documenter useful though possibly TMI.
    Try it first with the minimum options available an go from there.
    I did this (should have said), but it only shows me what query is related to another. What I need is a whole string of queries (THIS query is related to THIS query, which is in turn related to THESE queries, and so on), and for preference in a visual overview, like the visual overview of table relations. Is this possible?

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Quote Originally Posted by Nanuaraq View Post
    I did this (should have said), but it only shows me what query is related to another. What I need is a whole string of queries (THIS query is related to THIS query, which is in turn related to THESE queries, and so on), and for preference in a visual overview, like the visual overview of table relations. Is this possible?
    AFAIK no it isn't possible, as it could rapidly become unmanageable, slowing Access to a crawl or crashing it.
    But you can easily use the ObjDep tool in a dynamic way - a bit like cascading combo boxes
    Run it for one query then select another from the list the queries found, repeat as many times as the number of steps available

    Have a look at Access add-ins like MZ Tools & FMS Total Access Analyser.
    Both are highly regarded but are commercial products
    The latter looks like it may have what you need but it is expensive
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    nanuaraq,

    Can you give us an example or 2 of the kind of query relations you are dealing with?

  7. #7
    Robyn_P's Avatar
    Robyn_P is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Nov 2017
    Posts
    150
    It does that. It's not visual and doesn't show you what fields are linked, but you can expand the objects it depends on and it shows you in turn what they depend on

  8. #8
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Quote Originally Posted by Robyn_P View Post
    It does that. It's not visual and doesn't show you what fields are linked, but you can expand the objects it depends on and it shows you in turn what they depend on
    That's what I meant in my last reply but I think you explained it better
    Total Access Analyser provides more info but it's very expensive.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 10-17-2017, 04:46 AM
  2. Replies: 5
    Last Post: 10-12-2017, 12:12 PM
  3. Making tables "relate".
    By PATRICKPBME in forum Access
    Replies: 4
    Last Post: 03-06-2017, 02:02 PM
  4. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  5. Replies: 0
    Last Post: 02-24-2009, 12:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums