Mike Thomas wrote:
Access 2000 - Is there a 3rd party tool available, or perhaps some method
built into Access 2000, which could isolate unused Access reports, queries,
forms, etc?
I have a 5 year old app which has not always been cleaned up. I know there
are quite a few such no longer used items. I have a "Find" utility which is
good, but I need to look for every component individually - it is very time
consuming because there are hundreds of components in the app.
Many thanks
Mike Thomas
You could check out SpeedFerret.
You could roll-your-own if you are a programmer. You would need the
following knowdedge. For/Next, the Document object in order to check
all form/report/modules for references to Docmd.OpenReport, the Modules
object, how to scan all controls in a report to see if any are subforms,
how to add a record to a table (you would want to store the name of all
existing reports and in another table all reports you find for
comparision purposes), the FindMethod for the Module object, and the
ability to go back in lines in case the report is opened via a variable
name instead of the name of the report.
In fact, that would be the most difficult part of the program. Here are
2 examples
Dim stDocName As STring
stDocName = "TestReport"
Docmd.openreport stDocName
You'd need to loop back a line to see what stDocName is
Or
Dim strReport As STring
strReport = "TestReport"
Call OpenReportFile strRerport
Sub OpenReportFile(strReportName As STring)
Docmd.OpenReport strReportName)
End Sub
This would be a real PITA.