Comparing Database Tables...

[Calvin]

Does anyone know how a way to check two different Access
Databases to make sure that the table structure is the
same? I am using Access 97.

 

[Jeff Boyce]

Calvin

One approach would be to use Tools|Analyzer

 

[Jeff Boyce]

Sorry, fat fingers!

Tools | Analyze | Documenter will give you the table structures. Print them
both off and compare them.

Good luck

Jeff Boyce
<Access MVP>

 

[Özden Irmak]

Or you may try a tool which compares and even synchronizes access database
structures:

http://www.kliksoft.com/?S=2&SS=10

Regards,

Özden