 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / September 2005List of where objects are referenced in Access mdb
I need to search for where a query or an object is referenced through out the Access application. For example: would to like to know which reports, forms, modules, queries reference qryCustomer. Does access have a built in feature for finding objects or do you need to purchase software or do the MSDN cd's have this feature? Find And Replace from Rick Fisher at www.rickworld.com It's shareware and works a treat. Speed Ferret from www.moshannon.com/ It's a commercial product and is also highly recommended in the Access groups. HTH  Signature-Larry- -- > I need to search for where a query or an object is referenced through out the > Access application. For example: would to like to know which reports, forms, > modules, queries reference qryCustomer. Does access have a built in feature > for finding objects or do you need to purchase software or do the MSDN cd's > have this feature? If you are using access 2003, then you can right click on any object, and choose "object dependences" The result will show what objects it has dependences on it. It also gives the reverse, and shows objects depend on the object you just selected (it gives both). The only real downfall is this option turns on track-autoname correct. But, I just turn that off when done viewing the dependencies. SignatureAlbert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal@msn.com http://www.members.shaw.ca/AlbertKallal > If you are using access 2003, then you can right click on any object, and > choose "object dependences" [quoted text clipped - 5 lines] > The only real downfall is this option turns on track-autoname correct. But, > I just turn that off when done viewing the dependencies. Actually, there's another downfall, too -- although it does a pretty good job, it's not comprehensive. For example, your program might compute a name that it uses to access some object; a computed name will not appear in the list. So... yes, use Access 2003 if you can, but don't expect it to do all the work. (Check with Help for a list of types of references that won't be listed.) -- Vincent Johns <vjohns@alumni.caltech.edu> Please feel free to quote anything I say here. > Actually, there's another downfall, too -- although it does a pretty good > job, it's not comprehensive. For example, your program might compute a > name that it uses to access some object; a computed name will not appear > in the list. I totally agree with the above. Any code that prompts for a query, or lets a user "select" a query from a listbox etc. will not help (and, I tend to have lots of stuff like that). SignatureAlbert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal@msn.com http://www.members.shaw.ca/AlbertKallal |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.