List of where objects are referenced in Access mdb

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Albert said:
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.
Click to expand...


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 <[email protected]>
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.
Click to expand...

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).
 
Back
Top