To Search Whether A Query In Use or Not

[cheer]

There are more than 300 queries in my MDB. Any quick way to search whether a sub-query is in use or not as the sub-query may appear in other main query.

 

[James Deckert]

Not to the best of my knowledge. Microsoft used to have a utility that would search through everything (including queries) for something you typed in. I think it was in the developers kit. But it was for Access 2003 and I don't think it made it to the newer versions. You could select where you wanted to search. If you find a replacement, make sure you post it here. I used it.

The slow way I can think of is to copy/paste the sql from all queries into a Word doc, then do a find to see if the subquery name appears.

I think msysQueries contains all your queries. I found this post which may be useful to you http://stackoverflow.com/questions/17329223/what-does-the-data-in-msysqueries-mean

 

[RogerCooper]

Try the add-on http://www.accessdependencychecker.com/. This will create table with the text of all your queries, as well as other useful features.