How do I get the last inserted id, when it is autonumber?

[Petal]

Hi

I have this sql-statement:
Sql = "insert into user(user_name) values('"&Request.Form("user_name&quot&"')"
objCommand.execute(sql)

In the table user I have column named user_id that is autonumber.(MS Access).

How can I get the last inserted user_id?

Can I do it in another way than:

Sql="select user_id from user where user_name='"&Request.Form("user_name&quot&"'"

Please help me Jørn Arild Andenæs
jaa@jaa.no

 

[onpnt]

use this to go to the last record
user_id.MoveLast I may not get it the 1st or 2nd time,
but how sweet that 15th time can be.