Housekeeping

  • Thread starter Thread starter Gez
  • Start date Start date
G

Gez

I've inherited a database with a large number of queries some of which
appear to have been created on the fly. I want to remove any that are not
actively used within the database. I know how to search through code for
references to query names but is there an easy way of searching for query
names attached to forms, controls (e.g.listboxes and combos),reports and
macros. I'll also need to check for queries containing sub queries but I'm
not too bothered about that at the moment.

Cheers,

Gez
 
Cheryl gave you a good list. I own two:

Total Access Analyzer: This product is worth the cost IMHO. It will generate
cross-references that will tell you where the object is used (i.e. what
other objects "depend" on it, as well as a host of other items. what it does
NOT tell you is if your object is referenced in in-line code. for that you
need ...

Speed Ferret: will search through every line of code (including code behind
forms, reports, etc) and return EVERY place this object is referenced. I
actually use this more than TAA, but the products, while similar, do
different things.

Can't comment of Find and Replace as I don't own it. I did evaluate it and
decided to purchase Speed Ferret for several reasons, the biggest of which
is I wanted to make sure I could do the same thing in VB projects. Many
speak very highly of it AND it's cheaper than SF.
 
Back
Top