keeping track of query interdependencies 2

[Dougpeplow]

Is there any way of displaying, or charting, the hierarchy or interdependencies of queries (in a way similar to the 'relationships diagram' used for tables)?<br>

I have inherited a database with over a hundred queries, many of which are used as source queries for other queries etc etc...

 

[DougP]

you can &quot;Print out&quot; several items in Access '97 and I'm sure 2000<br>
click &quot;tools&quot; menu<br>
Click &quot;Analyze&quot;<br>
there is a whole host of info<br>
Try an example of one or two before you go print all of your queries because some of these reports are very BIG.<br>
and you may get informnation you don't want or need and waste a LOT of paper.<br>
OK<br>
<br>

 

[JimHorton]

Doug,<br>
There is a tool called Speed Ferret (I don't work for them and am not trying to promote it) that can help. I'm not sure about a-2000, but a-97 did not have anything like what you want. It had a 'documentor', which just listed objects, properties, etc. Speed Ferret won't list hierarchies, but it will list the location of all items you require, even if it's in a property box, query field, etc. I had a similar situation where I inherited a db with several hundred queries, and I could search or make name changes globally (thus avoiding that 'MS Access can't find the query xxxx') when you open up a query where you've changed the name of one of it's source tables. I think it's your best bet.<br>
--Jim

 

[elizabeth]

The Analyzer product from FMS at <A HREF="

http://www.fmsinc.com/"

TARGET="_new">

http://www.fmsinc.com/</A>

does exactly what you want. I used it in with Access 97 for a big mess that someone left to me and it was invaluable.