hi, this is my code:<BR><BR>SQL = "SELECT * FROM tbltest"<BR>rs.ActiveConnection = "DSN=mSQL;Uid=sa;Pwd=sapwd"<BR>rs.Open SQL, , adOpenStatic, adLockReadOnly<BR>response.write (rs.AbsolutePosition & "<BR>")<BR><BR>it keeps on showing &#039;-1&#039; although recordcount seems to work, and i do have adovbs.inc hooked up to the file too.<BR>what could the problem be? everything worked fine with my Access DB, but as i moved it to SQL2000 DSN, it gives this stupid error.<BR><BR>does anybody know how to fix this please?<BR><BR>thanks.<BR>Dmitri<BR>