Access record number

[hksr]

I have a microsoft access database, there is a record number that assign by the system itself. How can I extract record with that record number.

 

[vbkris]

that can be done in sql server like this, i dont know if it can be done in access but try it:

sql="select @@identity as id"
rs.open sql,con
response.write rs(0)

this code must come after the insert query...

Known is handfull, Unknown is worldfull