troubleshooting Question

How to loop thru all queries and find which one's were affected by a table change.

Avatar of bfuchs
bfuchsFlag for United States of America asked on
DatabasesMicrosoft AccessVBA
47 Comments2 Solutions160 ViewsLast Modified:
Hi Experts,

I am trying to get rid of many fields of a table that are not in use anymore, and we have a database of hundreds of queries and would like to know which of them would get affected by this change.

How can I loop all queries and get a list of all of them that are using one of those removed fields, which in that case when opening normally Access will display a message "enter parameter value.."

I guess something like the below for looping..
    For Each qdf In db.QueryDefs
        If Mid(qdf.Name, 1, 1) <> "~" Then
Join our community to see this answer!
Unlock 2 Answers and 47 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 47 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros