Search thorugh Access Database

Is there a way to search through all objects of a database to see if a particular object is being used?  FOr example, if I want to delete a query but don't know if it is being used in a macro or another query or a report, is there a quick was to search and find out?
melissalutz1Asked:
Who is Participating?
 
NetminderConnect With a Mentor Commented:
Per recommendation, points NOT refunded and question closed.

Netminder
CS Moderator
0
 
bob_onlineCommented:
no, not in any version of access I've used.
0
 
bob_onlineCommented:
Depending on what you're trying to accomplish, and the size of the database, the safest way to find out is to rename the object by putting an x in front of the name and then running the all of the code, queries, macros, etc.  If something doesn't work, just remove the x.
0
 
podekerkenCommented:
Rick fisher wrote add-in called something like Find & replace.
A very powerfull tool to do your cross examining.
www.rickworld.com

With kind regards Peter Odekerken
0
 
nico5038Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
 - PAQ'd and pts removed
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
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.

All Courses

From novice to tech pro — start learning today.