Can I retrieve the last Identity value inserted into database?

[oricteropo]

Is there anyway that I can retrieve the last identity column inserted into the database? In SQL Server Selecting the @@Identity variable will return this value but I have not been able to find it's equivalent in Access. Is this even possible?
Thanks in advance
-JK

 

[dhookom]

You can generally run a query:
SELECT Max([AutonumberFieldName]) FROM tblYourTable;
Or
DMax("[AutonumberFieldName]","[tblYourTable]&quot

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[cmmrfrds]

If Access 2000 or greater

On the same connection after the insert do

Select @@identity