Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2001
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Finding All Query Uses (Access 97)

    Is there a simple way to find out every query/form/report that uses a given query? I need to change a report, and it would be simplest to change one of the original queries, but I need to make sure that that query isn't critical to another report or form. This database was poorly written with queries nested multiple times within other queries. Thanks in advance.

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

    Re: Finding All Query Uses (Access 97)

    I don't think you can do it within Access itself, but you might want to pick up Total Access Analyzer. Not only will it help you with your specific request, it is very useful for documenting, cross-referencing, and error-checking databases. See http://www.fmsinc.com/products/analyzer/index.html.

    I've never needed to recursively determine what uses what (i.e. determine that x uses y because x uses a uses b uses c uses y), so you may need to manually do some work even with TAA, but it will definitely help a lot.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Mishawaka, Indiana, USA
    Posts
    145
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Finding All Query Uses (Access 97)

    Speed Ferret, http://www.moshannon.com/, provides a way to find all instances of a string, i.e. query name, in a database. I have been using if for a couple of years and have found it very useful. Check out their web site.

Posting Permissions

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