How to get auto-increment value after insert on ACCESS db?
843854May 22 2002 — edited May 29 2002When you insert a new record to a table with an auto-incrementing key, how do you find the value for the row you just inserted? This works differently with different databases. I know how it's done on ORACLE and mySql.
How does it work with ACCESS through ODBC? How about MSSQL?