Row cannot be located for updating vb6 access
This maybe a limitation of the provider,or of the selected locktype " I am using the code below for my update: Set rs = New ADODB. Open "Access", Con, ad Open Forward Only, , ad Cmd Table If Not txt User Number. Also, the Filter method works better for me in this context than the Find method. Especially when you contradict someone else who is trying to help too. This post has been edited by Bob Rodes: 07 April 2013 - AM Private Sub Command1_Click() Dim cn As Connection Dim rs As Recordset Set cn = New Connection cn. Are you saying that you check everything that you post and don't make mistakes? This means that your recordset is "dirty" between requeries if you don't do it every time you change a record, and doing that can cause unacceptable performance overhead if you are working with a lot of records. (Last one had to do with a less-than-complete understanding of how cursortype and cursorlocation interact, as I recall.) You have an impressive range of expertise and people listen to you. Especially when you contradict someone else who is trying to help too. Wow, sounds very much like you've been saving this up.Can any one suggest me solution to prevent this error Thanks in advance all of you from Amita Please help me on this problem. When I call the Update Batch method of an Active X Data Objects (ADO) Recordset object using the Microsoft OLE DB Provider for Oracle, an error may occur.With Microsoft Data Access Components (MDAC) version 2.5, the following error message may be returned: Run-time error '-2147217864 (80040e38)': Row cannot be located for updating.Text; //additional fields here Post; end; end; end; procedure Tfrm Edit Click(Sender: TObject); begin with frm Coin, tbl Main do begin if Show Modal = mr OK then begin Edit; Field By Name('Title')String:= edt Title. If yes, set the Cursor Location=cl Use Server With best regards, Mike Shkolnik Mike, That works..only if I comment this line out //tbl Main.
You will want to have the new data ready to go: Field1_Data = Input Box("Field1") Field2_Data = Input Box("Field2") etc...
Question TWO I have on and off been using Basic, now VB since “the stone age” long before Microsoft and Windows.
However it is only now I enter the issue of using VB6 and a database.
So I have a reason for wanting to iterate through the table. Thanks, John Brown You should try selecting the Return Matching Rows option in the DSN configuration dialog, or specify OPTION=2, as the connection parameter.
The value of int TF is actually determined by another table look-up.