Key Violation Message

[Les]

Alex,
Can you check your MS SQL table to see all the columns
that make up the keys. Most of the time it's that you
either are trying to append a record with a duplicate key,
or you have a column value in a key that is null. Did the
key violation message give any more info?

-----Original Message-----
I am attempting to append records from a pass-through

query in Access into a linked MS SQL table and I receive
the Message:

Microsoft Access can't append all the records in the

append query due to key violations