Append query and error

[Chi]

Hi,

I use the Append query to append information from the table A to table B. I
got an error message "Microsoft Office Access set 0 field(s) to Null due to a
type conversion failure, and it didn't add 13041 records to the table due to
key violations."

However, it works- It added 13041 records to table B- but I don't know where
the errors are and how to fix it.

Would you please show me what I should to do ?

Please help

 

[Jeanette Cunningham]

It sounds as if you are trying to add the 13041 records again.
I think that you ran the append query and it put the 13041 records in table
B, then you tried to run the append query once more and Access won't let you
put the same records in a second time and this is what the error message is
trying to tell you. This has happened to me on occasions.

Jeanette Cunningham

 

[Linq Adams via AccessMonster.com]

It would probably help t see the code where you're running the query.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[Chi]

Thank you so much Jeanette!! You are right!

Chi

It sounds as if you are trying to add the 13041 records again.
I think that you ran the append query and it put the 13041 records in table
B, then you tried to run the append query once more and Access won't let you
put the same records in a second time and this is what the error message is
trying to tell you. This has happened to me on occasions.

Jeanette Cunningham