Cross-reference of objects?

[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?

 

[John Vinson]

Is there a way I can get such a cross-reference?

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

 

[John Vinson]

But I don't think the names of the
programs would suggest to me that they do what I want!

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.

 

[Brendan Reynolds \(MVP\)]

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.

 

[Slow Moe]

Try this free one:
http://www3.bc.sympatico.ca/starthere/findandreplace

 

[Slow Moe]

Try this free utility:
http://www3.bc.sympatico.ca/starthere/findandreplace

as see it
http://www.freewarefiles.com/programs.php?ProgramID=7251&categoryid=10&subcategoryid=109

 

[John Vinson]

Try this free one:
http://www3.bc.sympatico.ca/starthere/findandreplace

Thanks, Moe - I'll check it out and add it to my list!