Append to autonumber error

  • Thread starter Thread starter JohnFol
  • Start date Start date
J

JohnFol

This sounds correct. If you include the new ID, and the same value of ID
already exists, you would get a key violation.
 
Hi
I'm having a problem appending into a large table, the only key in the ID
which is an autonumber (incrementa), whenever I try to append new records
(with any ID) I get a key violations, even though I didn't insert a key,
when I took the key off, it added existing values as ID, is this because I
have 270000 records?

thanks

Gal
 
No, No
I don't include the ID value, that's the whole problem!
Table 1:
ID autonumber
Name text
Table 2:
Name Text
then I append Name from Table 2 to Table 1 and I get the key violation,
makes no sense!

Gal
 
Back
Top