fetch current rec's AutoNumber ID

Hi list
Can anybody tell me how to get the record ID of a newly added record after updating the recordset ?
With MS Access as back end for our web application we used to do
rs.Open "SELECT * FROM table WHERE ID = -1)
rs.AddNew
rs("field1") = value1
rs("field2") = value2
etc
rs.Update

newID = rs("ID")

But this doesn't seem to work with MySQL (4.0.11) and MyODBC (3.51.06)
Any ideas ?

Thanks
ILyas