insert where autonumber exists in table?????

[Efa]

Can anyone help me with a basic query. I'm inserting details into a 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

 

[DJSmith]

can you paste your insert statement for when a autonumber is in use