Keep the old recordset and connection in place. Then create the new MySQLi recordset. At that point you can open the old server behaviors that use the old recordset and switch the connection to the new MySQLi version. When you click OK the associated code will be updated to MySQLi as well.
Let me know if you need help and I can do one or two pages in a screen sharing session so you can see how it is done.