Find unused components?

  • Thread starter Thread starter Ynot
  • Start date Start date
Y

Ynot

Is there a way to find unused code snippets, queries, forms and reports in
an old system? I want to clean it up and it is OLD!
 
Is there a way to find unused code
snippets, queries, forms and reports in
an old system? I want to clean it up
and it is OLD!
Click to expand...

Code snippets left over from now-deleted Controls are moved into the General
category, but with their original name. They are not, therefore, difficult
to find, though you do have to open the Module Window for each Form and
Report.

Unreferenced Queries, Forms, and Reports can be found using a third-party
tool such as Speed Ferret (http://www.moshannon.com) or Find & Replace
(http://www.rickworld.com) to search for their names, or one of the tools in
FMS' suite (http://www.fmsinc.com) such as Total Access Analyzer to create a
cross-reference list.

I worked on a Y2K Remediation project that used these very tools plus some
locally written Queries to clean up an older Access front-end before doing
the actual Y2K checks. We were able to remove a significant number of unused
objects and simplify the actual work of identifying items of interest in
regard to Y2K.

Be sure to retain an offline copy of the original... on one or two
occasions, someone got a little overenthusiastic and removed something that
we had to restore later!

Larry Linson
Microsoft Access MVP
 
Thanx for the advice Larry.

I will start playing with the code first then look at the available tools.
As you can imagine, this is not an emergency but I keep running across
little things I know are no longer part of the system and I would like to
clean them up.
 
Back
Top