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

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?
0
melissalutz1
Asked:
melissalutz1
1 Solution
 
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
 
NetminderCommented:
Per recommendation, points NOT refunded and question closed.

Netminder
CS Moderator
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now