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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Compare records in same access table 0
Difference beetween two tables with the same structure 1
Dynamic Table Linking 1
Comparing the Stru of 2 Different Tables 2
Excel Comparing two columns 1
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
Access Switchboard error message 1
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top