Posted By

wizard04 on 06/08/11


Tagged

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.