Cómo obtener el ID de un registro recientemente insertado?

[AlZuwaga]

Fijate si te sirve:

Código:

<% 
    fakeValue = 5 
    set conn = Server.CreateObject("ADODB.Connection") 
    conn.open "<conn string>" 
    set rs = Server.CreateObject("ADODB.Recordset") 
    rs.open "select [intField] from someTable where 1=0", conn, 1, 3 
    rs.AddNew 
    rs("intField") = fakeValue 
    rs.update 
    response.write "New ID was " & rs("id") 
    rs.close: set rs = nothing 
    conn.close: set conn = nothing 
%>

Tomado de aspfaq.com