tell me the maximum limit of records in recordset
Recordsets are dynamic and will return every row. The number of rows that can be batch updated are limited by the 'Maximum Open Rows property which defaults to 100. You can alter it:
rs.Properties("Maximum Open Rows") = 1000