Auto Generated Primary Key in MSAccess

[kazai]

While accessing MS Access table through ASP, I insert a row through a form page, using ASP. But the primary key is an auto number, called id. How do I incorporate this value in my Insert statement...do I need to incorporate it, or will it suffice if i just insert the values for the other columns.
Thanks,
Malavika.

 

[SauerC]

just leave the autonumber field out of the SQL Insert statement and it'll be fine.

-Christian