Find What Queries Insert Into Local Table

[jo15765]

I have a database with about 250 queries and close to 100 tables. Is there a quick way for me to tell what queries are associated with a table? Whether they Create the Table, they insert into the table or they select records from the table? Any query that has any association with the table? EDIT### This is access 2000

 

[Norie]

You could loop through the QueryDefs collection and check the SQL to see which tables are being referred to in each query.