List all row source for all forms, reports etc.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Darragh - 18 Jan 2008 06:14 GMT

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

Reply to this Message

John W. Vinson - 18 Jan 2008 06:45 GMT

>Hi
>
[quoted text clipped - 11 lines]
>
>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]

Reply to this Message

Darragh - 23 Jan 2008 02:12 GMT

On Jan 18, 4:45 pm, John W. Vinson
<jvinson@STOP_SPAM.WysardOfInfo.com> wrote:

> >Hi
>
[quoted text clipped - 25 lines]
>
> John W. Vinson [MVP]

Thanks John, I will investigate these options.

Darragh

Reply to this Message