Hi Chris, It depends on the type of cursor that you have opened the recordset with. You should use a keyset or static cursor. For example, RS.Open SQL, Connection, adOpenStatic, adLockReadOnly Also keep in mind that the recordset must be open at the time that you check the recordcount property. Dave http://java.dbmdata.com