Append based on INDEX

[Guest]

I have two tables with an Index of 3 fields. I want to append table 1 to
table 2 if the index is not same. Can the indexes be compared like that in a
querry? I had to have three fields in one index because each time 2 of the
three fields are same in both tables. Currently I have set the property for
table2 to have unique indexes, which in a way serves the purpose but each
time I run the querry it gives me alert that Access could not append x number
of rows due to violations etc. I do not want such warnings to be displayed
since other people may be entering data as we put the database to use.

 

[John Vinson]

Currently I have set the property for
table2 to have unique indexes, which in a way serves the purpose but each
time I run the querry it gives me alert that Access could not append x number
of rows due to violations etc. I do not want such warnings to be displayed
since other people may be entering data as we put the database to use.

Simply suppress the message. If you run the query from VBA code or
from a Macro, set SetWarnings to False before, and back to True after
you run the query.

John W. Vinson[MVP]

 

[Guest]

Thanx John. Just the thing I was looking for.

Simply suppress the message. If you run the query from VBA code or
from a Macro, set SetWarnings to False before, and back to True after
you run the query.

John W. Vinson[MVP]