Use a 3rd party tool like Speed Ferret.
FMS probably has a prodcut for this too.
--
Joe Fallon
Access MVP



"Roy Goldhammer" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello there
>
> I need to build a query tree analyzer:
> quries that base on other quries or not, which qurey are based on ect..
>
> for this i need simple tool to now on each query which table or query the
> query is using
>
> can someone help me to know whick table or query any query use without
> getting this information by the SQL?
>
> any help would be greatful
>
>
>
>

Hello there

I need to build a query tree analyzer:
quries that base on other quries or not, which qurey are based on ect..

for this i need simple tool to now on each query which table or query the
query is using

can someone help me to know whick table or query any query use without
getting this information by the SQL?

any help would be greatful