find queries from tables

[everhopefull]

Ok this might be a really stupid question, but in the quest to always make my life a little bit easier thought i would ask !

I have been asked to find the relationship between a number of tables and queries, so that this company can find out which tables and fields in tables are no longer really used, in other words how many queries and which ones is table A used in if you understand what I mean !

doing it manually means checking every query (and there are a lot !!) and seeing which table they use.. what I want to know is what is the quickest way to to this? can I do it from the table end? in others find out how many queries Table A is used in ? or do I have to go through each query individually? if this is the case my thoughts were just on copying and pasting the sql view from every query into a a word or txt doc and then doing a search /find for each table name? but if anyone has a more efficient idea on how to do this if u cld let me know !!

 

[everhopefull]

Thanks

Thanks Pat once I know there is a solution of some kind I can search further, I just didn't know if this was something that cld be done

rgds