Comparing Table Structures

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On an Access form, how do I compare two different tables for their
differences in table structure only?
 
Your question is unclear on what you are doing. A form does not have two
tables. It can have only one if it is a bound form. Can you be more
specific?
 
Hi Charles

This has nothing to do with a form, but is simply (?) a matter of comparing
every property of each of the tables, and each of the fields and indices
within them.

You could write some code to enumerate all of these properties and compare
their values, or you could avoid reinventing the wheel and use an existing
product, such as Total Access Detective from FMS
(http://www.fmsinc.com/products/detective/index.html). Of course, that
would cost you some money, but it's a great product. I use it often and
it's saved me hours of time.
 
Back
Top