Append query error

S

SMBR

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?
 
J

Jeff L

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.
 
S

SMBR

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?
 
J

Jeff L

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.
 
Top