Next Autonumber Value

  • Thread starter Thread starter Guramrit Singh
  • Start date Start date
G

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.
 
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
 
Back
Top