title: Scope_Identity() in Microsoft Access
body: <p>I'm writing a database in Microsoft Access to save the client from having to buy SQL Server.
  How do you get the primary key of the row that I just inserted?  In SQL Server, it's </p>
  
  <pre><code>INSERT INTO TABLE(FIELDLIST) VALUES(VALUELIST)
  SELECT * FROM TABLE WHERE PrimaryKeyID = SCOPE_IDENTITY()
  </code></pre>