Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003

    Unanswered: VB ADO Cursor Problems

    hello, i've inheritted a bunch of bad code that i wish i had time
    to rewrite and am having some problems with the cursortype of a recordset.

    i have a modular level recordset that the old programmer repeatidly opens and closes the recordset rather requery.

    i have found that the cursor type changes from keyset to forwardonly when he issues a .open

    there is no where in the code that the recordset is programmatically changed to have a forwardonly cursor.

    has anyone seen this? what can i do to force it to be a keyset?

    the value of the cursortype before the .open is 1 but immediately following the open its switched to 0.

    any help would be greatly appreciated.



  2. #2
    Join Date
    Jan 2003
    British Columbia
    I am assuming you are using ADO.

    ADO will automatically change the cursor type if the one requested is not supported by the provider or is invalid.

    For instance, if a Keyset cursor is requested it will be changed to a Static cursor if the cursor location is Client side (sqloledb provider).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts