I'm using ASP Classic for a legacy site we're working on. I'm using the ADO recordsets to get back information from the database.

Is there any way of finding the last insert id for the recordset, such as a built in keyword or function? Or do I have to get the last insert with a function and then add one to it?