Posted By

wizard04 on 06/08/11


database sql insert access autonumber

Versions (?)

Get ID of last inserted record in Access

 / Published in: SQL

Get the value of the autonumber field for the last record inserted into an Access database via the current connection.

  1. SET rst = objConn.Execute("SELECT @@IDENTITY")
  2. id = rst(0)

Report this snippet  

You need to login to post a comment.