Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

The DataSource property says that my recordset needs bookmarks. How can I find if my ADO recordset supports bookmarks?

April 26, 2017Ado Bookmarks DataSource Needs Property recordset supports

0

Posted

The DataSource property says that my recordset needs bookmarks. How can I find if my ADO recordset supports bookmarks?

1 Answer

0

Posted

The DataSource takes an ADO recordset and fetches data from the recordset to the control. The DataSource property may fail if the recordset doesn’t support bookmarks and notifiers. In order to check if your recordset supports bookmarks and notifiers use the Supports property of the recordset like in the following VB sample: Debug.Print “Bookmark support: ” & rs.Supports(adBookmark) Debug.Print “Notify support: ” & rs.Supports(adNotify) where the rs is an ADO object. If one of the Supports(adBookmark) or Supports(adNotify) value is False, the DataSource property fails. The control requires a bookmarkable recordset to identify a record when the user changes a value in the grid. The control requires the Notify support to update the control once that an ouside source changes the recordset. Additional, if the control’s property DetectDelete or DetectNew is True, the CursorLocation property of the recordset must be adUseClient.