How to get the Id of something i currently inserted into access db

Question

i found many answers to this question for other databases, but didn't found any answer for Microsoft access.

I have a table that has the following columns : ID A B C the id is auto number , how do i get the ID of a row i just inserted.

btw : i'm using C#

thanks

Answer 1

See the MSDN article here. In MS Access, you'll want to SELECT @@IDENTITY within the scope of the statement which inserted the record.