What is the equivalent to SQL Servers SCOPE_IDENTITY()?
Posted on 2006-07-19
I am building a class that has to deal with MS Access.
A vast majority of the code is working.
One of the methods is GetIdentity().
This uses the SQL statement "SELECT SCOPE_IDENTITY() AS lastID;" and returns the ID of the last row inserted.
What is the MS Access equivalent. I understand that MS Access does not require a primary / unique key, so I don't know what to do.
If the table has no uniqueness then false is a valid return value for me.
The answer must be via SQL as I'm NOT using ADO/DAO/etc to communicate with the databases.