@@Identity in MS Access

MSAccess 2000 or later supports the @@IDENTITY property to retrieve the value of an autonumber field after an Insert is executed.

Check out the following MSDN Link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconRetrievingIdentityOrAutonumberValues.asp

Submitted by : David Wier