How to find "unused" queries

[Guest]

We have designed a database which, over the years, has accumulated quite a
number of queries. I'm sure that many were designed for a "one time" report
and were never deleted. Is there a way I can find out which queries are not
being used by any forms or reports so I can delete them? I could do it
manually by going through each of our nearly 200 reports and 20 forms &
subforms but needless to say, that prospect does not excite me! Thanks in
advance...

 

[Douglas J Steele]

Take a look at Total Access Analyzer, from FMS
http://www.fmsinc.com/products/analyzer/index.html

 

[Guest]

Thank you, Douglas. The problem with the so-called "Help" in any Microsoft
application is that you need to know what to ask for. I never would have
thought of looking for an "analyzer."