How to determine what objects use a query

[glenn69]

I would like to know how to do the following:

Query 'X' is a sum query.
How do I determine which other queries use Query 'X'

I want to make some changes to Query 'X' but I want to be sure of which other queries will be affected.

Thanks

 

[DJkarl]

I would like to know how to do the following:

Query 'X' is a sum query.
How do I determine which other queries use Query 'X'

I want to make some changes to Query 'X' but I want to be sure of which other queries will be affected.

Thanks

If you are looking for an easy answer there really isn't one. If you have Access 2003 you can use the Documenter feature (Tools>Analyze>Documenter) but that really doesn't help much other than it gives you the SQL for each query, which you could get faster if you wrote your own function in VBA to cycle through querydef objects.

If you have a small number of queries I'd open each one and look at it, if you have a large number of queries then it's up to you how you want to proceed.