Which Recordset Objects Support Bookmarks?

Dynasets based on certain linked tables, such as Paradox tables that have no primary key, do not support bookmarks, nor do forward-only-type or snapshot-type Recordset objects opened with the dbOpenForwardOnly constant.

You can determine whether a given Recordset object supports bookmarks by checking the value of the Bookmarkable property, as in the following example:

If rstLinkedTable.Bookmarkable Then
	MsgBox "The underlying table supports bookmarks."
Else
	MsgBox "The underlying table doesn't support bookmarks."
End If

If you try to use bookmarks on a Recordset object that doesn’t support bookmarks, a run-time error occurs.