How to get an automatic number value after inserting an Access library record?
First, you must ensure that the Bookmark property is supported by the record set, such as 1,3.
After inserting a record with an automatic number field, get the Bookmark property value of the record:
Temp = rs.bookmark
then:
rs.bookmark = TEMP
Try:
Response.write rs.fields ("id")