List all row source for all forms, reports etc.

[Darragh]

Hi

I'm doing some work cleaning out old unused forms, reports and
queries. I have been going through each report in a database (There
are A LOT), determining its row source query, then marking it for
deletion. I will eventually end up going through and deleting all the
unused queries. As you can imagine this is time consuming, and I was
thinkg 'there must be a FASTER way"

Does anyone have a suggestion, or link to a pre-built function or
model that could assist me?

Regards

Darragh

 

[John W. Vinson]

Hi

I'm doing some work cleaning out old unused forms, reports and
queries. I have been going through each report in a database (There
are A LOT), determining its row source query, then marking it for
deletion. I will eventually end up going through and deleting all the
unused queries. As you can imagine this is time consuming, and I was
thinkg 'there must be a FASTER way"

Does anyone have a suggestion, or link to a pre-built function or
model that could assist me?

Regards

Darragh

Some third party tools can really help here:

Free: http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

Total Access Analyzer in particular has a very extensive dependency report and
a tool to find "orphaned" queries or code. It's not free (or even very cheap)
but it's well worth the price if you have to do this kind of exercise even a
couple of times.

John W. Vinson [MVP]

 

[Darragh]

Some third party tools can really help here:

Free: http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer:http://www.fmsinc.com

Total Access Analyzer in particular has a very extensive dependency report and
a tool to find "orphaned" queries or code. It's not free (or even very cheap)
but it's well worth the price if you have to do this kind of exercise even a
couple of times.

John W. Vinson [MVP]

Thanks John, I will investigate these options.

Darragh