Cross-reference of objects?

  • Thread starter Thread starter GaryS
  • Start date Start date
G

GaryS

Is there a way to get Access to show me where all a given
object (e.g., query, macro, etc.) is used (referenced)?

My database is under development, and there is a lot
of "construction junk" lying around in it, such as one-
time conversion queries and temporary tables.

I would like to clean it up by deleting those objects
which are not used/referenced by the objects I want to
keep.

Is there a way I can get such a cross-reference?
 
Is there a way I can get such a cross-reference?
Click to expand...

Four; unfortunately only one is free and included in Access, and it's
a lot of work. In increasing order of price and power:

- Use Tools... Analyze... Documenter. Export the report to Word (as a
..rtf file) and search the voluminous document for the names.

Or, purchase one of three third-party programs designed for just this
purpose:

Find and Replace http://www.rickworld.com
Speed Ferret http://www.moshannon.com
Total Access Analyzer http://www.fmsinc.com
 
But I don't think the names of the
programs would suggest to me that they do what I want!
Click to expand...

I use both Speed Ferret and Total Access Analyzer and (names
notwithstanding) they can do exactly this. Speed Ferret in particular
can very quickly find (and if you wish, change) any name in the
database, indicating in which form (query, report, VBA code, ...) it
found the name, and the context. I'm sure Find and Replace can do so
as well.
 
I can confirm that Find and Replace has a cross-reference facility. It's
disabled in the shareware version, but enabled when you register. It's not
as powerful as TAA of course (I can't comment on SpeedFerret, not having
used it) but then it's only a fraction of the cost.
 
Back
Top