I tried both of those and neither would run either, although I might have needed to leave out the command object with the syntax:
rs.Open([SQL command], [Connection string], 3);
However, I did find that doing this worked:
RS.CacheSize = 10;
RS.CursorType=3;
RS.Open(cmdTemp);
>The problem is in optional parameter. You can use this:
>
>rs.Open(cmdTemp,Conn,3);
>
>
>but this is repetition of defining ActiveConnection. In your case you can consider using implicit connection (if this connection isn't used by other commands):
>
>rs.Open([SQL command], [Connection string], 3);
>