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 PROTECTED]
