Latest autonumber inserted?

  • Thread starter Thread starter Eric Caron
  • Start date Start date
E

Eric Caron

Hi all,

In Access 2000, is there a way to know the value of the autonumber field of
the last record inserted, apart from doing a MAX(autonum_field) + 1 in a
second query? I am looking for something like @@IDENTITY in SQL Server and
I fear that the MAX() method would introduce bugs if there are many inserts
in succession.

Any help would be appreciated.
 
No, there isn't. You can do your table Inserts via recordsets, which could
of course return the UniqueID.
 
Hi,

This is what I thought... I will proceed with a recordset for the inserts
then.

Thank you Scott
 
Back
Top