• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

Looking for All Occurrences of a Query

What is the easiest way for me to do a search on where a particular query occurs in the database application. I would like to see a list of wherever this query is defined or called. This includes all objects within the database, e.g., modules, forms, tables, etc.
0
geeta_m9
Asked:
geeta_m9
  • 5
  • 5
  • 3
  • +2
3 Solutions
 
mbizupCommented:
I haven't used this myself but many Experts here highly recommend this Find and Replace tool:
http://www.rickworld.com/
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Best tool ever ... I use is daily.

http://www.rickworld.com/products.html#Find%20and%20Replace%209.0

Get it.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Well worth the price and have used it for years.   And it's not just a simple find and replace; there is a cross-reference utility in there that is great for figuring out and cleaning up old databases.

Jim.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
In fact, the functionality is second to none.
You can even search table fields for data ... and a LOT more.

mx
0
 
Dale FyeCommented:
concur with all of the above.
0
 
geeta_m9Author Commented:
The website doesn't appear to  have an evaluation copy, though. You have to purchase it right away.
0
 
Dale FyeCommented:
The second paragraph at:

http://www.rickworld.com/products.html#Find%20and%20Replace%209.0

says:

"The unregistered shareware version is available for download."

and contains a link.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
You can evaluate - but not all features are available ....

mx
0
 
geeta_m9Author Commented:
Yes, I noticed that.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
If you plan to work with Access dbs ... this tool is indispensable ... worth 100x the cost.

mx
0
 
geeta_m9Author Commented:
You are right! This tool works very well.

Thanks for the recommendation! I found I was looking for very quickly.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Don't skip the cross-reference utility...it's a button off to the right.

What it does is scan the entire DB and notes where an object is used.  For example, will tell you every place your query is called.

More importantly though it can return a list of all objects not used, which is very handy in cleaning up an old DB.

Jim.
0
 
geeta_m9Author Commented:
Noted, thank you!

G
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Example of searching specific Fields in a table - for example say you have a Configuration table (or whatnot) - maybe you have have some query names in it - whatever. You can have F&R optionally search these custom properties ... VERY handy.

F
mx
0
 
geeta_m9Author Commented:
Some of these features are not available to me currently because I don't have the full version yet. However, I think I will purchase it. It is a pretty handy tool and doesn't cost very much.
0
 
Dale FyeCommented:
as MX mentioned, easily worth 100x the cost.

If you are a professional developer, or are developing for your office, you can easily save the cost of the product the first time you use it to find, in your case, all instances where a particular query is referenced.

Even bigger help when changing the name of a field in a table, and all of the queries/reports/code where that field name is used.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 5
  • 5
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now