ADO and SQL Server

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.