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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber records inserted in gaps 1
AutoNumber Field (Access 2007) 5
How to retrieve the autonumber after an insert? 4
Autonumber associated with date 0
"Multiple Autonumber" in same table 2
Annoying Autonumber bug 2
Changing a number field to Autonumber 5
Autonumber preservation 4

Back
Top