List of All Objects With Dependencies

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

Guest

Is there any way to generate a list of all objects with their dependencies?
In particular, I am trying to get a list of reports/queries with their
subreports and subqueries. I am creating a list of reports for my users to
select from, and it would help me narrow it down if I could figure out easily
what the top-level ones were. I can look at the dependencies for an
individual object on the screen, but I can't see any way to look at multiple
objects or to print the information. Ideas, anyone?
 
Click on menu TOOLS - Analyze - Documentor.
Click on Reports. Select your options and run. Save to Word by clicking on
the W icon on the tool bar.
Search in Word.
 
Which options should I select? I haven't seen any marked "Dependencies", and
"Properties" doesn't seem to help.
 
Is there any way to generate a list of all objects with their dependencies?
In particular, I am trying to get a list of reports/queries with their
subreports and subqueries. I am creating a list of reports for my users to
select from, and it would help me narrow it down if I could figure out easily
what the top-level ones were. I can look at the dependencies for an
individual object on the screen, but I can't see any way to look at multiple
objects or to print the information. Ideas, anyone?
Click to expand...

There are some good third-party tools to do this - Total Access
Analyzer probably is what you'll need to get the full benefit (it's
worth the nontrivial price in my opinion).

Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

John W. Vinson[MVP]
 
Is there anything within Access itself? This is for my work computer, and in
order to buy anything, I have to go through my boss, IT, and Accounting, and
by that time I'll have given up and done it all longhand :)
--
Amy E. Baggott

"I''m going crazy and I''m taking all of you with me!" -- Linda Grayson
 
Is there anything within Access itself? This is for my work computer, and in
order to buy anything, I have to go through my boss, IT, and Accounting, and
by that time I'll have given up and done it all longhand :)
Click to expand...

<wry grin> I'm afraid not, at least not that I've found.

You can find references in VBA code - using the binoculars/Search
option and selecting "Entire Project" - but AFAIK there's no easy way
to find which forms are linked to other forms, or which queries
reference one another, without writing quite a bit of VBA code.

John W. Vinson[MVP]
 
Back
Top