Re: Determining whether a query is used elswhere

On Mon, 30 May 2005 17:05:19 -0700, "Meryl"
<Meryl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>I have a lot of queries in my db, some of which I want to get rid of.
>However, I'm not sure if some of them are used by another query, form or
>report. Is there a way I can determine that? Sort of "where used" report?
>
>Thanks.
>Meryl

There's no easy builtin way to do this. Some third-party tools have
been developed to do so:

Free:
http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

John W. Vinson[MVP]
.

Relevant Pages

  • Re: Import problem from AS400
    ... write queries on the AS/400. ... This seems a lot cleaner than having to deal with the report writer you ... Any suggestions on how I can get rid of this will be great. ...
    (microsoft.public.access.externaldata)
  • Re: show all the records for a field in a report
    ... Table and queries have ... Do you mind sharing your SQL view? ... >I am trying to run a report to show all the records in a certain field. ... Prev by Date: ...
    (microsoft.public.access.reports)
  • quarterly date queries generating annually
    ... can someone give me advice on best to have quarterly date queries ... For example I have a report which has dates for four quaraters: ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Can I enter comment lines in Expressions, etc....
    ... I want to document the logic behind certain expressions, queries and report ... Dave ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Enter Parameter Value keeps appearing
    ... The second summed the item totals. ... report that lists Item, SumOfQty and SumOfAmount. ... problem is that Name is not in either of my queries or my ... get rid of if. ...
    (microsoft.public.access.queries)