I am getting the following error:

error '800a0e7d'
The connection cannot be used to perform this operation. It is either closed
or invalid in this context.

The strange thing is that I am using

set member=server.CreateObject ("ADODB.recordset")
Then I access DB via
member.Open "select * from Refer_Table where Username='" & MembersEmail&"'",con
I do some updates and thenwith no problem
member.close

then I access twice more two distinct tables in the DB with code similar
to the above with no problem

I am trying to access a fourth table via
member.Open "select * from New_Table where Username='" & MembersEmail&"'",con

and I am getting in this line the error 800a0e7d.

Any help will be greatly appreciated.