How to get a car number after INSERT in Ms Access?

Question

I have the following query in VBA:

DoCmd.RunSQL "INSERT INTO table (value) VALUES ('example')"

(with automatically incrementing primary key called id)

How can I get the auto-increment identifier generated by this insert?

Answer 1

I believe what you are looking for:

@@Identity

It is similar to SCOPE_IDENTITY in T-SQL. Check out this article for more information:

http://www.mikesdotnetting.com/Article/54/Getting-the-identity-of-the-most-recently-added-record