CRecordset - get automatically generated identifier after update ()

Question

Once you have called Update () on an MFC CRecordset (ODBC / Dynaset), what can I do to pull out the automatically generated identifier without having to click the database again? Ideally, whatever it is, it will work both in SQL Server and in MS Access (so the query for the last identifier may not work ...)

Answer 1

Unable to execute. The second time you need to click on the database to pull out @@ Identity. Bummer.