AbsolutePosition

Sets or returns a long value that is the ordinal position of the cursor.

 

The AbsolutePosition property sets or returns a long value that is the numeric position (ordinal position) of the current record in the Recordset object. The AbsolutePosition property may also return one of the PositionEnum constants. Note that you cannot set this property to any of the PositionEnum constants.

 

This property only points to a position and should not be used to uniquely identify a record, since additions, deletions, sorts and other operations can easily rearrange the contents of a recordset.

 

When you set this property to a position number, you will be moved to the record at the position you have specified. In addition, the Recordset cache is reloaded. The records in the cache will now start at the numeric position in the Recordset you have specified. The total number of records that can be stored in the cache is set by the CacheSize property.

 

The first record is always numbered one. You can use the RecordCount property to determine the total number of records in the Recordset.

 

You can only use this property if it is supported by the provider. You must also be pointing to a valid record when attempting to use this property. If you are not pointing to a valid record, this property will return one of the PositionEnum constants which specify the current position of the record pointer in the Recordset. You may also need the set the CursorLocation property to adUseClient since the default for this property is adUseServer.

 

 

PositionEnum Constants 

 

Recordset, Stream.Position.