Get ID of last inserted record in Access - SQL Snipplr Social Repository

Revision: 47447

at June 8, 2011 06:46 by wizard04

Initial Code

set rst = objConn.Execute("SELECT @@IDENTITY")
id = rst(0)

Initial URL

Initial Description

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

Initial Title

Get ID of last inserted record in Access

Initial Tags

database, sql

Initial Language

SQL