I am using ASP (with VBScript) to work with an Access database. I want to create a record, and then immediately obtain the auto-generated ID field for that record. I tried something like this:

rs.Open etc...
rs.AddNew
rs("name") = "spandex"
rs.update
recordid = rs("ID")

However, this doesn't work. It doesn't give me a value at all.

How can I do this?