i have an access database that my primary id is autonumber, every time i try to insert a record i get the following error

You tried to assign the Null value to a variable that is not a Variant data type.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: You tried to assign the Null value to a variable that is not a Variant data type.


Is there a way to insert the record with autonumber with?

Typically when you want to insert a row into a table that has an autonumber (or identity in MSSQL) field, you need to omit that field name from your insert statement. Otherwise, you have to provide a value for the field which is where you are running into the problem.

-Peter

Hi im very new to ASP.NET. Just started using VS.NET.
I have the same problem when i try to connect to a access db. what line of code should i remove/add to fix the auto nr thing?


Johan