Name

Recordset.Bookmark Property — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

                     bookmark = recordset.Bookmark

The Bookmark property returns a unique identifier for the current record within a recordset. By setting the Bookmark property to a previously read value, the record pointer can be repositioned to the original record.

Datatype

Variant

Description

The Bookmark property is available only through recordsets that support bookmarks. Bookmarks are used to record the position of the current record and later to set the current record back to the specified bookmark.

Bookmarks can be used interchangeably within Recordset objects that are clones of each other, but not with other Recordset objects, even if they were created from the same source.

The return value of the Bookmark property is not readable and shouldn’t be used in comparisons because two bookmarks of the same record may not be the same.

Note

Not all recordsets support the Bookmark property.

See Also

CursorOptionEnum Enumeration, Recordset.Supports Method

Get ADO: ActiveX Data Objects now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.