Inserting records into tables with autonumber

[LAazsx]

Hi, how do i enter data into tables with columns which have datatypes of Autonumber?

Here is the code column that has a datatype autonumber when i created it in SQL Management Studio

CaseNumber int IDENTITY(1,1) NOT NULL PRIMARY KEY

When I imported the tables into Access, the column CaseNumber was set to Autonumber. I've done some research but I can't get it to work.



What I found goes like this:
INSERT INTO (col2,col3) values ('value2','value3');
col1 needs not to be included because it is autonumber.

[ajetrumpet]

when you perform an append query like that, access will throw an error if you try to append an actual value, regardless of the source, into the autonumber field. don't append anything. it will increment on it's own.

what exactly is not working?