Database Analysis of Existing DB's

[D. Harrigan via AccessMonster.com]

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
databases.

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

Any help is appreciated.

Thanks,
D. Harrigan

 

[John Vinson]

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
databases.

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

Any help is appreciated.

Thanks,
D. Harrigan

Depends on your budget, but the FMS Inc (www.fmsinc.com) 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]