After opening a recordset from an ADO connection I can no longer insert new records?

I have a sub that connects to SQL, creates a couple of temp tables, and opens a recordset from one of the temp tables. After opening the recordset, it creates another temp table called #Temp5 and attempts to insert records. However, I'm getting an error message that the object name #Temp5 is not valid. It's strange because I don't get any error when creating it, but it's like creating the table never even happened. When I comment out the opening of the recordset earlier in the sub, the values are inserted into #Temp5 without a problem


Does anyone know the logic behind this?

After looking into this a bit more it appears that I can't alter any part of the connection when the recordset is open, but that still doesn't explain why I'm not getting an error when trying to create the table in the first place

I tried a few more things and this is what I found:

-If the Create table and insert values statements are all done in ONE execute command, there is no error regardless of if the recordset is open. If they are done in separate commands one after the other, there will be an error if the recordset is open but not if the recordset is closed

-The temporary table IS being created when the recordset is open but still not recognized when trying to insert records. If I open the recordset, create the table, close the recordset, and try to create the table again, i will get an error saying the table already exists. However if I try to then insert values somehow it's not recognized