Next Autonumber Value - 02-02-2010 , 11:50 PM
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.
LOGIC ERP Solutions Pvt. Ltd.
Re: Next Autonumber Value - 02-08-2010 , 06:48 AM
AFAIK Access uses @@IDENTITY. See :
http://support.microsoft.com/kb/232144/en-us (INFO: Jet OLE DB Provider
Version 4.0 Supports SELECT @@Identity)
"Guramrit Singh" <guramrit (AT) msn (DOT) com> a écrit dans le message de
news:9D910F2F-0753-44C6-B8A3-427BDA69F33C (AT) microsoft (DOT) com...
Re: Next Autonumber Value - 02-23-2010 , 09:57 AM
I was trying this with @@Identity, in a tableadapter and I cannot get this
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.
"Patrice" <http://scribe-en.blogspot.com/> wrote
|Thread Tools||Search this Thread|