Next Autonumber Value

[Guramrit Singh]

Hello Everybody,
I want to get next autonumber(indentity) value for row to be inserted in a
table within a transaction of MS Access, In VB6, I can do the same using
recordset.addnew, and then I was able to get autonumber value before update.
In SQL Server I can do the same using IDENT_CURRENT('table_name') and
IDENT_INCR, but I am unable to do the same in MS Access.

 

[Patrice]

Hello,

AFAIK Access uses @@IDENTITY. See :
http://support.microsoft.com/kb/232144/en-us (INFO: Jet OLE DB Provider
Version 4.0 Supports SELECT @@Identity)

 

[Miro]

Quick question.

I was trying this with @@Identity, in a tableadapter and I cannot get this
working.

Im assuming this is not an option with the tableadapter? (you must use it
with manual sql) - I even tried to set the tableadapter query to scalar.

Miro