Hi,

I'm new to Access and was trying to find out how to retrieve the record
identity after an insert...

Some postings I read suggested using MAX() to retrieve the inserted record
id, but that's not reliable, because another user or session could have
inserted a record in the same table too...

Fo example, in MS SQL after an insert, there are 3 ways to retrieve the
newly generated identity of the inserted record:

1) IDENT_CURRENT - returns the most recently inserted record id in a table
regardless of which process or session inserted it.

2) @@IDENTITY - returns the most recently inserted record id in a table
regardless of which process inserted it, but inserted in the current session.

3) SCOPE_IDENTITY - returns the most recently inserted record id in a table
by the current process in the current session.

How can this be done in Access? Has Access an equivalent functionality for
each of these 3 SQL features?

Thank you very much in advance,

Rick