Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005

    Unanswered: assigning adodb recordset to form


    Im working on a upsizing project with a sql-server backend.
    The following problem occured: in the open-form method I defined an ADODB recordset, specified the connection, cursortype, cursorlocation, locktype and assigned the opened recordset to the form.
    That works fine, all fields where shown, the recordset can be modified directly with form.recordset("fieldname") = "xyz" but: when I try to modify the field via the bound control like form.control.value = "xyz" there comes the error 2077: recordset cannt be updated.

    Is there something special with that kind of recordset handling? The same sql-statement bound to the form works fine also with updating.


  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    Have a look at your recordset. ADO is very picky about what it will allow you to update. Lack of primary key, joins... there is a lot that will make an ADO dataset cranky.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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