I am getting the following error:
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
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.