can't append all record in the append query

C

ched_sen

please help I am getting this error message Microsoft access can't
appends all the record on the append query Micosoft Acess set 0 fields
(s) to null due to a type conversion failure, and it didn't add 2
reccords to the table due to key violation, 0 record due to lock
violations and 0 record due validation rule violaton. I have limited
experience with access database.
thanks
chedly
 
C

confumbled

Are you trying to append a value to the autonumber field? This would be a
cause.
 
J

John Vinson

please help I am getting this error message Microsoft access can't
appends all the record on the append query Micosoft Acess set 0 fields
(s) to null due to a type conversion failure, and it didn't add 2
reccords to the table due to key violation, 0 record due to lock
violations and 0 record due validation rule violaton. I have limited
experience with access database.
thanks
chedly
Click to expand...

Well, the message means what it says: that it cannot add the records
because - for two of the records - doing so would violate some key
condition that you have defined. There are various reasons for this
error; you might be trying to add two records with the same value of a
Primary key field, or other unique index; or you might be trying to
add a record that doesn't have a matching value in some related
table.

Could you post the SQL view of the append query you're trying to run,
and some information about the primary key and relationships of the
table into which you're appending?

John W. Vinson[MVP]
 
Top