How can I get the last inserted id from access?

Hi, is there a way to get the last inserted id from access (the autonumber key).

Im using java 1.3 and access 2002 sp3.

I know this is possible using a prepared statement in mysql but I cant seem to find anything for access.

This is the driver im using:

sun.jdbc.odbc.JdbcOdbcDriver

thanks.

[327 byte] By [deaconj1234a] at [2007-11-26 22:24:20]