Return autonumber in Access like @@Identity

[objuan]

Can anyone tell me how to return the AutoNumber from Access much like you can return the @@Identity in SQL?

 

[jfrost10]

Here's how I did it:

'First I execute a command object to insert a new record
objCmd.ExecuteScalar()

'Immediately after, I reset the command object's text
'property to the value below, set its command type (I'm
'using stored queries in Access, hence specifying
'commandtype.text...you may not have to do that line)
'and execute the command. This will return the new
'autonumber.
objCmd.CommandText = "Select @@Identity"
objCmd.CommandType = CommandType.Text
Return objCmd.ExecuteScaler()

hth, and let me know if you need anythign else.

D'Arcy