Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 @@Identity

Author  Topic 

sirmilt
Starting Member

49 Posts

Posted - 2012-06-16 : 11:56:46
Is there an equivalent to the @@Identity in Access?
I searched the Access help files and couldn't find one.

Milt

sirmilt
Starting Member

49 Posts

Posted - 2012-06-16 : 12:03:43
A quick reply to my own qustion.
The Microsoft KB gives the answer, it is:

SET @Identity = SCOPE_IDENTITY()

Milt
Go to Top of Page
   

- Advertisement -