The Access Order property sets the order in which columns must be accessed by methods that operate on recordsets, rows, and streams.
object.Properties("Access Order") [= value]
object
Expression that evaluates to an object in the Applies To list.
value
Integer specifying the access order as described in 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. |
adInteger
Read/write
DBPROP_ACCESSORDER
For optimal performance and interoperability, applications should set the Access Order property to DBPROPVAL_AO_SEQUENTIALSTORAGEOBJECTS.