find used queries (1 Viewer)

[Access_guy49]

Hey, I know this is probably a silly question but,
Is there a way to find out if any of your queries are used in forms or reports?
I want to delete a bunch of queries in a database but I don't know if they are used somewhere as a reference or filter or anything.

 

[pbaldy]

Duplicate thread:

http://www.access-programmers.co.uk/forums/showthread.php?t=180966

 

[statsman]

Best place to start looking is in macros and modules.

See if any of the queries are listed there.

You will then have to open up each form and report in design view to see where they are getting their data from.

The short answer is to leave well enough alone unless the database is so big it is effecting performance or too large to run. Someone created these queries at some point for some reason. While a few of them may be redundant, is it really worth the substantial effort to find out?