Very Computer

If I am using an SQL insert inside of VB with dao for instance connected via
ODBC to sqlserver7 database, how do I get the value of the identity or
autoincrement field as the record is added.  I realize that using the
.addnew method on the recordset will make the value of the identity field
immediately available.  However I want to use the .execute method with the
database i.e db.execute("INSERT " & yada yada yada)  Now, that I have just
executed the insert statement, how can I get the value of the AutoNumber
field that is a part of that record.  I can't just look at the last record
as I have 25 concurrent users all adding records and by the time I re-query,
I may have an additional 25 records on top of the one just added in this
example.

Please help me.
Chris

remove the .no.Spam to make it work

Well, the way I see it you have two choices -

1) requery the DB with the user's name or other identifier

2) use the rs.addnew method.  

What's wrong with the .addnew method?  The cursor required may be slow,
but certainly not as slow as going back to the DB on some text search.

R

To actually perform this from VB you would open a recordset for the stored procedure. The recordset will contain one row with one column that will be the Identity value just inserted. The transaction makes sure you get the right value no matter what other users are doing at the time.

Regards,
Simon Jones
MillStream Design
Independent IT Consultants

Chris -

app.  Then again, I could be way off on this as I don't use ADO.

-jeff