update recordset

Results 1 to 2 of 2

Thread: update recordset

  1. #1
    Join Date
    Dec 1969

    Default update recordset

    Hi, I&#039;m getting the following error when trying to update a recordset<BR><BR>ADODB.Recordset error &#039;800a0e79&#039; <BR>Operation is not allowed when the object is open<BR><BR>The ado constants i&#039;m using are <BR>adopendynamic = 3<BR>adlockoptimistic = 3<BR><BR>Do I need to change these?<BR>thanks<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: update recordset

    Set the cursor type and lock type before opening the recordset.<BR>The CursorType and LockType property is read/write when the Recordset is closed and read-only when it is open.<BR><BR>

Posting Permissions

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