Key Violation Message

R

rob

probably because in your relationships you are connecting
two of the exact same fields. one of them is probably a
primary key and the other is not. i had this problem
just make both of them primary keys or both of them not
anything.

i would need more info to help you if this doesnt help.

hope that helps,
rob

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