Append Query

  • Thread starter Thread starter Kathy
  • Start date Start date
K

Kathy

I am trying to run an append query and I keep getting the
message that there is a key violation. I have compared
the two tables that I am trying to append to/from and the
only difference that I can see is that one of them has
the field that I am appending as a primary key; (Index is
(Yes, no duplicates)) and in the other table the field is
not the primary key so the Index is (Yes, Duplicates
OK). My problem is that when I try and make the field
the primary key in the second table, it won't let me. Is
this what is preventing me from successfully appending
these tables? And, if so, how do I correct the key
violations?
 
If you have duplicate values in the field, you won't be
able to change it to a primary key. You may want to try
appending from the table with the primary key to the other
table, if your goal is to have all the data in 1 table.
 
Back
Top