Skip to content

Instantly share code, notes, and snippets.

@wizard04wsu

wizard04wsu/autonumber.vbs

Created May 1, 2014 18:45
Show Gist options
  • Save wizard04wsu/11458690 to your computer and use it in GitHub Desktop.
Save wizard04wsu/11458690 to your computer and use it in GitHub Desktop.
Download ZIP
Get ID of last inserted record in Access
Raw
autonumber.vbs
'Get the value of the autonumber field for the last record inserted into an Access database via the current connection.
set rst = objConn.Execute("SELECT @@IDENTITY")
id = rst(0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment