Accessing autonumber colummn in access

[Mitre]

hi, i made a data type for a column autonumber in access... i wanted to have a unique number in this way.. the column is named " id"

Tried accessing it the following way but failed.. any ideas to solving this problem ??

SQL = " INSERT id FROM table "
.....
......... ( code to execute SQL statement)

dim abc
abc = RS("id")
Response.Write abc

[tomcat99]

Why INSERT * FROM table. If this is what I think it is, SELECT, then you should have no problems to access your id field. Are you using ADO?

tomcat

[Mitre]

No sorry not using dao when i posted this message... was using ASP and a little VB Script for this web task. But now i am doing another non-web project using Cdao... thks anyway