I am opening a recordset with the following command.<BR>RS.OPEN SQL, "DSN=HPOTTI;UID=SA;PWD=", adOpenStatic, , adCmdText<BR><BR>And I am checking the recordcount with RS.RecordCount and absolute position with RS.AbsolutePosition. I am getting both the values as -1. There are total 3 records in the table. What coulb be the reason. Thanks in advance.