Append to autonumber error

[JohnFol]

This sounds correct. If you include the new ID, and the same value of ID
already exists, you would get a key violation.

 

[Gal Zilberman]

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

 

[Gal Zilberman]

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