Comparing Tables

[DirtyB]

I have several tables here that are ALMOST identical in structure. I've got vba code and queries that need to work for all of these tables. The problem is that there must be a few fields that are different between the tables. There are so many fields in these tables that it's almost impossible to compare visually. I can't figure out how to print the design view of a table, then I may be able to compare them visually, but other than that....does anyone have any ideas on how to do this?

THanks

 

[jimmythegeek]

You can print out the table fields and info using Tools | Analyze | Documentor.

Select the tables you want, go to options, and make sure all of the "Include for Form" check boxes are UNchecked, and only "Name" is selected for Sections and Controls. Otherwise, it prints out a bunch of stuff that you really aren't concerned about when you are comparing tables. Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?

 

[DirtyB]

Thanks so much, that helps a lot.