Hi All, I was trying to append some records to a table and got the Key Violations error message. Upon investigating, I discovered that a new record added to the table creates a duplicate number in the autonumber field (which is set as the primary key, not to allow duplicates.) I have never seen this happen before. Any ideas on how I fix it. I use Access 2010.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.