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.


--
Regards,
Guramrit Singh
S/W Developer
LOGIC ERP Solutions Pvt. Ltd.

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)

--
Patrice

"Guramrit Singh" <guramrit (AT) msn (DOT) com> a écrit dans le message de
news:9D910F2F-0753-44C6-B8A3-427BDA69F33C (AT) microsoft (DOT) com...

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

"Patrice" <http://scribe-en.blogspot.com/> wrote