I have some code for looking at the hierachy of objects in a database
The Procedure 'QueryStructure' Looks for to find references to any query or table in all queries tables forms and modules. It doen't look in reports as yet and will think a reference to 'qry11' is also a ref to 'qry1'
There are also a few other bits and pieces which may be of use.
NB 'QueryStructure' only works with 2000 or later due to references to AllForms and AllModules