insert values to access table

Hi all,

i have created a table in MSAccess and the primary key i have set to Autonumber.
but while inserting from the code part how i can give a value to the primary key in the insert statement.

please give me a solution as soon as possible
thanks in advance
Dev.

primary key as an autonumber means the number increases by 1 by each row,
you can not change an autonumber...

leave the autonumber out of the insert statement and jus tinsert your other data...

the problem is if i leave primary key its says wrong no of arguements passed to the query.

Post your SQL...