Access Append Query to Linked SQL Server Table

[Guest_imported]

Hey, I'm stumped on this one and would appreciate any help. I'm running an append query, pulling data from a temp table I've built in Access, and updating a linked table in SQL Server. There are 3 primary fields on that table -- I am not violating referential integrety. I have manually entered the same information at the SQL Server leve with no problems. When I run the Access append query I get the "....., and it didn't add 146 records to the table due to key violations...." Help! Thanks.

 

[tlbroadbent]

Access is telling you that ...

1) a primary key field is duplicated OR
2) a unique index on another field is being duplicated OR
3) you are violating a foreign key constraint. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.