ADO - Get New Record ID

[ProjectExplorer]

I am adding a new record to an Access table using a OleCommand and SQL string containing "INSERT INTO tblOrders etc...." The back end table contains a AutoNumber field to generate a unique Order ID ("OID")as soon as the new record details are inserted by the code.

My problem is that I need to get the new Order ID (OID) as soon as the record is added (inserted) into the table but I cannot see how I do this with ADO.

I used to do this in ACCESS DAO using:

With rstOrders
.AddNew
.Fields ("Packs") = Me.cboPacks ' i.e. number of packs
intOID = .Fields ("OID") ' GET THE NEW ORDER ID
.Update
.Close
End With

Basically you could grab the new Order ID (OID) as soon as the new record was created (because DAO remains connected to the database).

I am not not how I can recreate this with ADO or what approach to take to acheive it.

Any help much appreciated.

Thanks

 

[jebenson]

This tells how:

http://support.microsoft.com/default.aspx?scid=kb;en-us;815629&Product=adonet

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!