Using MS Access as back end, how do i.....

[stephenmbell]

I am looking to get the ID of the last inserted record in an msaccess db. I
know in sql server you can select @identity or @@identity - but this doesnt
work in msaccess.

any help would be greatly apprecitated.

ty

smb

[The ScareCrow]

@@identity does work in ms access as long as your using 2000 +

But the following will work as well

Select Max(ID) As maxid
from tableName

But you need to enclose the insert query and the select query in
cftransaction, to ensure that both queries are performed as one

Ken

[Dan Bracuk]

I always add the biggest where clause I can produce to the query suggested by The ScareCrow.