You had updated the connection in the code without updating the recordsets that refer to it. You shouldn't be editing the code directly. Just open the recordset and change the connection there. That will add the new connection and update the recordset code on the page automatically.