Is there a way to return the Identity ID after an insert using the Connection object. I am using the following code:

Conn.Open strConnection
Set cmd.ActiveConnection = Conn
cmd.CommandText = strSQL
Set rs = cmd.execute

The insert does not return the inserted record.

rs.fields.Count always =0

Is there a way to get the return of the inserted record?

Thanks for you help