Will this work with access97 with an oledb 4.0 ----- Original Message ----- From: "David L. Penton" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Monday, August 19, 2002 3:53 PM Subject: RE: Getting last ID from an INSERT into an Access database
> Sure you can...in most situations. But if you can use the @@IDENTITY, it is > far faster and creates less traffic on the wire. > > David L. Penton, Microsoft MVP > JCPenney Application Specialist / Lead > "Mathematics is music for the mind, and Music is Mathematics for the > Soul. - J.S. Bach" > [EMAIL PROTECTED] > > Do you have the VBScript Docs or SQL BOL installed? If not, why not? > VBScript Docs: http://www.davidpenton.com/vbscript > SQL BOL: http://www.davidpenton.com/sqlbol > > > -----Original Message----- > From: Michael Elfial [mailto:[EMAIL PROTECTED]] > > Or just use > recordset.Open ... > recordset AddNew > recordset("field").Value = something > ... > recordset.Update > ID = recordset("TheIDField").Value > > > > -----Original Message----- > From: Nick Middleweek [mailto:[EMAIL PROTECTED]] > > Hello, > > What is the best way to get the value of the unique ID field from an Access > database using ADO/SQL after INSERTing a new record. > > Does IDENTITY exist in Access? > > > Thanks, > Nick > > > --- > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] > To unsubscribe send a blank email to %%email.unsub%% > --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
