Hi Jon, why do you use "rs.Bookmark = 1"? You could use rs.MoveFirst to go to the first record. As far as I know the bookmarks are of string data type.
For example: Dim sBookmark as String ' declare some bookmark rs.MoveFirst ' go to first record rs.MoveNext ' move some steps forward rs.MoveNext rs.MoveNext rs.MoveNext sBookmark = rs.Bookmark ' take current position into bookmark rs.MoveFirst ' goto first record rs.Bookmark = sBookmark ' this jumps to the bookmarked position Hope this helps, I did not try it, but it should work with any bookmarkable database. Tilmann Starke SOFTWORK GmbH Help to prevent global warming by writing cool software. -----Urspr�ngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Im Auftrag von JON Gesendet: Mittwoch, 29. Januar 2003 05:52 An: [EMAIL PROTECTED] Betreff: A problem with ADO - ODBC and maybe bookmarks Using ADO recordsets under VB here's the pertinent sequence of events as I can discern it: 0) I scroll through the recordset (count = 9) hitting EOF, going back to a spot in the middle, doing MovePrevious until BOF is true. Eveything seems fine. 1) The recordset hits BOF = true. 2) rs.BookMark = 1 (this moves it to the first record in the recordset and executes successfully, BOF = False, there's good values in the recordset.) 3) rs.MoveNext (this gets an error: -2147217887 Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.) I can't imagine why I get any error. Any clues? Does anybody also have any clues how I can check the various errors generated by OLE DB in this environment? Thanks, Jon _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
