Get the last inserted value
Posted on 2004-08-21
I would like to get the autonumber that was generated by an insert statement returned to my web application (asp.net C#)
For example, in MS SQL I have a stored procedure that inserts the record and returns @@Identity as the output parameter.
In this way I am guaranteed that I am getting the identity generasted for the last inserted record - and not the value of another record that may have come in at the same time (such as would be the case if I did something like a SELECT MAX)
How is this done in Access?