Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Melbourne, Victoria, Australia
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query Hierarchies

    I've inherited a spaghetti A97 application which has ~120 tables and ~500 queries, quite often with similar names (but no naming conventions).

    Is there a utility/tool available that can flow chart or show the hierarchy of what reports use what queries, and in turn what queries/tables are used by these queries, ad infinitum.

    If I nominate a query/report then I would, ideally, like a flow chart of all subordinate queries/tables which make up the top level query/report.

    I have used Tools->Analyzer->Documenter which shows what queries/tables are used in a query/report. But if I want to know all subordinate queries/tables then I have to manually trace and document.

    Regards
    Michael

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Query Hierarchies

    <A target="_blank" HREF=http://www.fmsinc.com/>FMS Inc</A> has a whole suite of developer tools, including Total Access Analyzer. You can download demos of most of their products, so it's possible to try before you buy.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Melbourne, Victoria, Australia
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query Hierarchies

    Thanks Charlotte,
    I actually had downloaded Total Access Analyzer a while ago but only read the documentation, didn't fire it up.
    It didn't seem to be able to do what I wanted, but I'll give it a full workout this time.
    Regards
    Michael

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query Hierarchies

    I'd suggest going for Total Access Analyser as well. I've been using it in my databases. It has NUMEROUS reports (you can easily use hundreds of pages of paper documenting a complex database if you're not very judicious about the reports you choose), and you should find something to approximate any sort of cross-referencing you want. It's also very handy for checking for errors in your database.

    Unfortunately, I have never felt that the demo did it justice.

  5. #5
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Melbourne, Victoria, Australia
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query Hierarchies

    Hi Douglas,
    I downloaded the demo last night and had a play with it.
    The Summary tab when selecting Object Diagram is what I'm after, certainly beats manual tracing.
    I've placed the order with our IT Purchasing Department.
    Regards
    Michael

  6. #6
    zxis
    Guest

    Re: Query Hierarchies

    Check this site out for some decent freeware toolz. Visual Designer gives a query report that's not too bad. Best of all the price--FREE.


    http://www.ozemail.com.au/~tdambra/

  7. #7
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Melbourne, Victoria, Australia
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query Hierarchies

    Hi,
    Thanks for the reply. It sounds interesting, but I am having no success in downloading a copy of it. When I get redirected to Audio Highway and click to download, which I've tried on a number of occaisons, I get an error message that the site is not available.
    Regards
    Michael

  8. #8
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: Query Hierarchies

    Hi, (bringing to life an old thread... <img src=/S/smile.gif border=0 alt=smile width=15 height=15> )
    I'm also looking for a freeware alternative that provides this kind of info.
    Have there been developed some new alternatives since then?
    It also looks like not too much of a task to derive such info from the Access system tables (if you know how these are built) - is it? If I can work something out, I'll let you know. Any suggestions, meanwhile, are welcome...

    FYI: the recent address of Tony D'Ambra's site is: http://www.accessextra.net/. Unfortunatly the add-on referred to here is no longer free (still cheap though).

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Query Hierarchies

    Access 2003 (and presumably 2007) supports tracing up to four levels of object dependencies. Unfortunately, it requires that Track Name AutoCorrect Info is turned on, a setting that is known to cause problems, so I and others always recommend to keep it turned off in all databases... <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

    See About object dependencies (MDB).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •