Adding a record in SQL with an autonumber

[Shuja Ali]

As the field is an AutoNumber field, you do not have to explicitly mention it in your SQL INSERT Statement.. The field will be incremented by the SQL Server automatically..

You need to remove the field that is set to Autonumber from your Query..