PRB: INSERT INTO (append query) and autonumber field

[Vladimir]

[MS Access/SQL]

I have a table named MyTable with two fields: Field1
as AutoNumber and Field2 as Long Integer. Primary
key is on Field1.

When I try to execute following append query

INSERT INTO MyTable ( Field2 )
VALUES (1234)

I get the message saying that query fails due
to key violation. Obviously, it is Field1 that
causing a problem, but isn't it an autonumber?
I've expected that Field1 will automatically get
next available value.

Is it possible to overcome this problem?