Getting the ID of a new record

C CORDON · Feb 8, 2005

How can I get the ID (in a autonumber field) for the last added record in
access?

TIA!

TF · Feb 8, 2005

This should work:
SELECT @@IDENTITY FROM table

TF

Paolo · Feb 9, 2005

OleDbCommand idCMD = new OleDbCommand("SELECT @@IDENTITY", dbConnection);
newID = (int)idCMD.ExecuteScalar();
This worked for me!