The Maximum Pending Rows property specifies the maximum number of rows that can have pending changes at the same time.
object.Properties("Maximum Pending Rows") [= value]
object
Expression that evaluates to an object in the Applies To list.
value
Integer that specifies the maximum number of rows that can have pending changes.
adInteger
Read/write
DBPROP_MAXPENDINGROWS
This limit on the maximum number of pending rows does not reflect resource limitations such as Random Access Memory (RAM), but does apply if the recordset implementation uses some strategy that results in a limit.
If there is no limit, the value of the Maximum Pending Rows property is set to zero. The provider is free to support a greater number of pending rows than the maximum specified by the application. In this case, the provider will return the actual maximum number of pending rows instead of the value specified by the application.