Hi
Does anybody know of a function or sample code that will tell me the last auto increment id from an insert query. I know of a function 'mysql_insert_id' in php but is there something similar in VB?

I used the max(id) to achieve what I wanted:

strSQL = "Select Max(id) as lastID FROM " & strTable

I use this to get the Autonumber form a table that resides in SQL

Set Tbl = MasterDbConn.Execute("Select @@identity As XPropertyID")
LngLoginKey = Tbl.Fields("XPropertyID").Value