Find redundant queries / tables / reports easily?

R

Richard Horne

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?
 
J

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]
 
Top