Queries - Where Used Query?

[GUIDO22]

Hello - I have a fiar few queries defined in my database - what I need is a damn good clear out!

I need to identify those queries that are utilised either called directly from VBA or defined as recordsource properties in my form designs. Is there a query I can run that tells me ALL queries utilised throughout the DB?

I can then delete those that are not in the query results...... any ideas please would be gratefully received!

Thank you.

 

[allan57]

Hi check the following link

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

 

[GUIDO22]

Hi check the following link

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

Thanks Allan - yes, it was me that raised this back in 2005! Had lost the code.... let us thank the archives...!!!!

 

[GUIDO22]

Allan - one further question - the field in the table - Query_In_Use_By_DB - resulting records all have the value false...? What purpose is this field and how does it work - I couldnt quite understand the code in the last For loop....