I see now... you named your recordset the same thing as your connection. The recordset is overwriting the connection. You need to rename the recordset manually at this point because a find/replace will update both.
with some other name on lines 58-62 and then again on lines 167 and below. Don't replace the other instances since they are referring to the connection not the recordset.