Latest autonumber inserted?

[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.

 

[Scott McDaniel]

No, there isn't. You can do your table Inserts via recordsets, which could
of course return the UniqueID.

 

[Eric Caron]

Hi,

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

Thank you Scott