Knowing which tables are used in queries

[ejhatch]

Hi All,

Is there any standard Access functionality which can tell me which tables are used in each of my queries.

Failing that has anyone ideas on some query I could develop or code that I could write which would give the required output.

Thanks,

Evan

 

[llkhoutx]

There's no such functionality in Access.

One could parse the tables container and programmatically unpack all queries, but coding it would be more trouble that it's worth.