recordset

[khushi]

tell me the maximum limit of records in recordset

[willakawill]

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