Find redundant queries / tables / reports easily?

[Guest]

Hi guys, I've created quite a comprehensive database with a good number of
tables, queries, reports and forms, and am now preparing the database to be
used for real by the company I work for.

During the course of building the database, I've been a bit slap dash when
trying to work things out, so I have a few forms, sub form, reports and
queries that can probably be deleted, but the problem is I can't easily
figure out which ones are redundant with deleting them and testing fully.

Is there a simple way of finding out which are redundant? Or is it simply a
case that I need to make a backup, delete each item individually, then test
to see if the database still works with that part deleted, rinse and repeat
till I've gone through every table, form etc which I think is redundant?

 

[Joseph Meehan]

Hi guys, I've created quite a comprehensive database with a good
number of tables, queries, reports and forms, and am now preparing
the database to be used for real by the company I work for.

During the course of building the database, I've been a bit slap dash
when trying to work things out, so I have a few forms, sub form,
reports and queries that can probably be deleted, but the problem is
I can't easily figure out which ones are redundant with deleting them
and testing fully.

Is there a simple way of finding out which are redundant? Or is it
simply a case that I need to make a backup, delete each item
individually, then test to see if the database still works with that
part deleted, rinse and repeat till I've gone through every table,
form etc which I think is redundant?

The documenting feature should give you the information you need to
figure it out. I suggest that even then you should always have a back up
copy and in this case you can try changing the names (like add "old" to the
existing name) and then testing out the functions. If they still run, you
are OK.

 

[John Vinson]

Hi guys, I've created quite a comprehensive database with a good number of
tables, queries, reports and forms, and am now preparing the database to be
used for real by the company I work for.

During the course of building the database, I've been a bit slap dash when
trying to work things out, so I have a few forms, sub form, reports and
queries that can probably be deleted, but the problem is I can't easily
figure out which ones are redundant with deleting them and testing fully.

Is there a simple way of finding out which are redundant? Or is it simply a
case that I need to make a backup, delete each item individually, then test
to see if the database still works with that part deleted, rinse and repeat
till I've gone through every table, form etc which I think is redundant?

In addition to the Documenter (Tools... Analyze... Documenter) there
are some good third-party tools to help with this. I particularly like
Speed Ferret for the purpose, but they're all useful. In increasing
order of power (and price):

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

John W. Vinson[MVP]