I am new to msaccess/vba.

To verify that the design of a given mdb matches a refernce mdb I tried to loop through the tabledefs and compare them.
However, I get a type mismatch error on the if statement:

dim tdfRef as tabledef, tdfTarget as tabledef
for each tdfRef...
  for each tdfTarget...
    if tdfRef=tdfTarget

Presuambly I'd need to compare indexes as well but the idea is stuck here.
1. Is there a way to do this comparison?
2. Is there a better way to do the design comparison.

I am not interested in comparing the data contents.
Thanks.

Tim

__________________
Tim

You cannot do this comparison directly. For this to work, there would have to be some value for the equality-comparison operator (the equal sign) to compare. What would the value of a tabldef be?

You are going to have to get the fields out of the one tabledef, then, using each field's name, retrieve that field from the other tabledef and see if they have the same type, size, etc.

Comparing databases is an arduous undertaking. . .

Thanks.
tdf is afterall just a data-structure.
So by operator overloading this is easily possible had it been implemented.
Guess not in VBA.


Tim