How to get an automatic number value is obtained immediately after inserting the Access record

zhaozj2021-02-16  166

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")

转载请注明原文地址:https://www.9cbs.com/read-8334.html

New Post(0)