I need to be able to insert a record into an Access2K table using ADO2.1 and be able to access the new record to retrieve the database ID

Something like: -

set rs = con.execute("INSERT INTO table (fldFieldName) VALUES (fieldvalue)")

dbID = rs!ID

This inserts the record OK but does not return a recordset.

Can anyone tell me what I'm doing wrong.