×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Key Violation errors - Expert advice needed

Key Violation errors - Expert advice needed

Key Violation errors - Expert advice needed

(OP)
I have a table that I am try to add new records to using an append query.

All the fields in the query are of the same data type as the table i am appeneding into, everything matches perfectly but when I run the query i get the error msg, "didn't add XX number of records to the table due to key Violations".

Now if I remove my primary key from the AutoNo ID field in my table they append OK but as the key is removed, they append all over the place and not sequentially as the existing records are. Access starts assigning IDs from EXISTING records to the new ones which means when I display the records in a from, the wrong records show up.

Any ideas on what I am doing wrong here ?????

Thanks in advance,


Sallyg

RE: Key Violation errors - Expert advice needed

Sally,

It is not "doing wrong", it is understanding!

If you have an autonumber field in the destination table, the destination table MUST assign the number to each record as it is created - IN THE DESTINATION table!  Importing a value into this field is the violation.  You can either have the autonumber field in the source table - and import the value into a (long integer) field in the destination table - or you can have the destination table autonumber the impor records - not both!

MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

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.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close