insert where autonumber exists in table?????

[Efa]

Can anyone help me with a basic query. I'm inserting details into a access database from a java servlet. My table contains the following

ID - autoNumber
fisrt - string
last - string


My problem is my data won't insert when i use the auto number. Am i doing something wrong. If i don't use the autoNumber is adds fine but i need this feature.

Any help is greatly appreciated.


Efa

 

[sailorjwd]

It might help to see the query statement you are using for the insert. However, I suspect you have the ID field in the insert statement. This is a no no. Remove the ID field from the insert statement - Access will automatically populate the ID field.

Joe.

http://www.blueclaw-db.com/