What does this mean and why is it doing this?

  • Thread starter Thread starter Dawn
  • Start date Start date
D

Dawn

I am trying to merge some databases and using the query
and keep getting this error.

SIS database set 0 field(s) to Null due to a type
conversion failure, and it didn't add 128 records to the
table due to key violations, 0 record(s) due to lock
violations, and 0 record(s) due to validation rule
violations.

What does this mean?

Thanks
 
It means that the data that you are appending contains 128 records with
primary key values that are the same as records already in the destination
table.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2002 Append Query Problems 1
Running into error while writing Append Query 2
How do I avoid key violations in append queries 7
Type conversion failure on Append 12
Strange warning message 1
Access Can't Append Message 3
What does this error mean? 1
Remove warning pop up choice 4

Back
Top