Maximum Pending Rows Property
The Maximum Pending Rows property specifies the maximum number of rows that can have pending changes at the same time.
Applies To
Command Object | Recordset Object |
Syntax
object.Properties("Maximum Pending Rows") [= value]
Parts
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.
Data Type
adInteger
Modifiable
Read/write
OLE DB Property
DBPROP_MAXPENDINGROWS
Remarks
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.