In one of my ASP pages I execute an SQL Insert query to
add a new record into a table, it works well. One of the
fields in the table however is an AutoNumber field, I can
add a new record but what I need is to be able to work
out what number is automatically assigned to the new
record?

Are there any good methods to do this?
TIA