How to get the last auto-increment value in MS-Access, for example, @@ Identity on Sql Server

Question

I want to get the identifier column value in ms access from an auto-increment column. I basically do a transaction in which I have to write two insert requests. The second query will contain the auto-increment value that was created from query 1. How can I do this?

Answer 1

However, Microsoft Access 2000 or later supports the @@ IDENTITY property to get the value of the Autonumber field after INSERT

:

. @David-W-Fenton, Jet 4.0 OLE DB Provider ( )