get recordet id after insert

keyvanjan · May 9th, 2005, 03:39 PM

Hi,
How can I get the recordset ID after inserting it with sql command in ms access db?
thanks

jbenson001 · May 9th, 2005, 11:51 PM

You can use @@Identity to get the identity of the row just inserted.

Prashant.k.m · May 10th, 2005, 01:48 AM

hi,

The previous post is tad misleading
@@Identity is in MS-sqlserver

You can go for select max(Id) from yourTable
Immideatly after inserting , also put the both in a transction.

This will work in any back end DBMS

Prashant

leo_vinay · May 13th, 2005, 12:56 AM

@@identity works well in Access(2000), no idea of earlier versions.

regards,

Vinay

happygv · May 13th, 2005, 06:34 PM

Keyvanjan,

Did that solve the problem?

_________________________
- Vijay G
Strive for Perfection

keyvanjan · May 14th, 2005, 05:15 AM

yes,thanks.@@identity helped