ADODB.recordset and querying twice

[pelegk1]

i have 2 queries which i want to make with the same object
so i did :
set rs=Server.CreateObject("ADODB.recordset")
rs.open "select count(uid) from table1"
response.write rs.RecordCount
rs.Close
rs.open "select count(uid) from table2"
response.write rs.RecordCount
but i get -1 on the second rs.Open
why is that?
thnaks in advance
peleg

[Bullschmidt]

Instead of this:
rs.Close

Perhaps use this:
rs.Close
Set rs = Nothing