Database Analysis of Existing DB's

Database Analysis of Existing DB's

Post by D. Harriga » Sat, 04 Mar 2006 02:34:33

I have 25 access databases. They are all very similar, and built from the
same template. But some have different fields , reports, queries. I need to
analyze these databases for normalization so that all the databases have the
same fields and determine which new fields should be included in all the

I'm not sure of the best way to do this. Should I build an Access database
and pull in each table from each of the databases to try to determine the

Any help is appreciated.

D. Harrigan

Message posted via

Database Analysis of Existing DB's

Post by John Vinso » Sat, 04 Mar 2006 04:35:31

On Thu, 02 Mar 2006 17:34:33 GMT, "D. Harrigan via"

Depends on your budget, but the FMS Inc ( programs
Total Access Analyzer and Total Access Detective are specifically
designed to do just this. They've saved me endless hours of work.

I'm not associated with FMS in any way, just a grateful customer.

John W. Vinson[MVP]