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]] Sent: Sunday, August 18, 2002 9:38 PM To: ActiveServerPages Subject: Getting last ID from an INSERT into an Access database 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]
