Maximum Open Rows Property
The Maximum Open Rows property specifies the maximum number of rows that can be active at the same time.
Applies To
| Command Object | Recordset Object |
Syntax
object.Properties("Maximum Open Rows") [= value]
Parts
object
Expression that evaluates to an object in the Applies To list.
value
Integer that specifies the maximum number of rows.
Data Type
adInteger
Modifiable
Read/write
OLE DB Property
DBPROP_MAXOPENROWS
Remarks
This limit on the maximum number of 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 Open Rows property is set to zero. The provider is free to support a greater number of active rows than the maximum specified by the application. In this case, the provider returns the actual maximum number of active rows instead of the value specified by the application.