'recordset.Open Source, ActiveConnection, CursorType
try using the dynamic cursor i.e.
change
rs.open("select * from table", "Connection String")
to

rs.open("select * from table", yourConnection,2)