ADO and SQL Server
Access Order Property
The Access Order property sets the order in which columns must be accessed by methods that operate on recordsets, rows, and streams.
Applies To
| Command Object | Recordset Object |
Syntax
object.Properties("Access Order") [= value]
Parts
object
Expression that evaluates to an object in the Applies To list.
value
Integer specifying the access order as described in Settings.
Settings
| Constant | Description |
| DBPROPVAL_AO_RANDOM | Columns can be accessed in any order. |
| DBPROPVAL_AO_SEQUENTIALSTORAGEOBJECTS | Columns bound as storage objects can be accessed only in sequential order as determined by the column ordinal. Storage objects from one row must be retrieved before retrieving any columns in any subsequent row. |
| DBPROPVAL_AO_SEQUENTIAL | All columns must be accessed in sequential order determined by the column ordinal. Further, all columns from one row must be retrieved before retrieving any columns in any subsequent row. |
Data Type
adInteger
Modifiable
Read/write
OLE DB Property
DBPROP_ACCESSORDER
Remarks
For optimal performance and interoperability, applications should set the Access Order property to DBPROPVAL_AO_SEQUENTIALSTORAGEOBJECTS.