Append query error

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

Guest

I am trying to append a table onto another table. I have set the primary
keys to the same field in each table and the properties of each field are the
same. I am still getting key errors when I attempt to append. What else
could be the problem?
 
A lot of times when you get key errors, you are trying to add a key
value to the table that either already exists in the table or does not
have a value. Key values must be unique and cannot be null. If this
doesn't help you, it might be good to post the error message you are
getting.
 
I'm sorry, but by key value do you mean fields that are set as the primary key?

I do have some records that are blank for some fields. Could that be
causing the problem?
 
Yes, by key value I am talking about values you are adding to the
primary key. If you are trying to append a blank value to the primary
key field, you will definately get an error.
 
Back
Top