Re: Row cannot be located for updating

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Val Mazur (group51a_at_hotmail.com)
Date: 09/04/04

  • Next message: Val Mazur: "Re: OleDataAdapter>> ADO.NET Question.......changing a dataset field value with a stringvar. Who can help me withit" 
    Date: Fri, 3 Sep 2004 21:08:50 -0400

    Hi David,

    Check if it helps

    http://support.microsoft.com/default.aspx?scid=kb;en-us;193515&Product=ado

    http://support.microsoft.com/default.aspx?scid=kb;en-us;294842&Product=ado 

    -- 
Val Mazur
Microsoft MVP
"David Beers" <DavidBeers@discussions.microsoft.com> wrote in message 
news:01589E2C-F56E-4816-B396-93D7432808E7@microsoft.com...
> I'm writing a VB6 application that parses a text file, loads the data into 
> an
> intermediate Access database, and then synchronizes the data with a Palm 
> OS
> device via the Palm Conduit Developer Kit.  (The Palm aspect is probably
> unimportant)
>
> I am able to open a connection with the Jet.OLEDB.4.0 Provider, create a
> recordset and add records to a table in the database, performing an 
> rs.update
> with each record.  Then the recordset gets passed to another part of the
> application with performs the Palm sync and I'm able to successfully read 
> the
> data and write it to the database in the Palm.  But after doing that I 
> need
> to modify and update a couple of fields in the Access database.  When I 
> make
> one more rs.update to accomplish this I get an error:
>
> "Row cannot be located for updating. Some values may have been changed 
> since
> it was last read."
>
> I don't understand why all the previous updates worked fine and this one
> fails.
>
> I'm using client-side cursor, adOpenDynamic, and adLockOptimistic
>
> I've tried closing the recordset and reopening a fresh one, but that 
> doesn't
> seem to help.  I read somewhere to use rs.Resync before I update, but that
> gave an error "Single-row refresh operation returned multiple rows."  I 
> read
> that I need to have a primary key established, but this didn't seem to 
> help
> either (and in any case, I've written conduits very similar to this one
> without assigning a primary key and not had this problem).
>
> I seem to be out of ideas and a little desperate, as I've lost a whole day
> now with this problem.
>
> -- 
> David Beers
> Pikesoft Mobile Computing
> www.pikesoft.com
  • Next message: Val Mazur: "Re: OleDataAdapter>> ADO.NET Question.......changing a dataset field value with a stringvar. Who can help me withit"

    Relevant Pages

    • Row cannot be located for updating
      ... intermediate Access database, and then synchronizes the data with a Palm OS ... Then the recordset gets passed to another part of the ... without assigning a primary key and not had this problem). ...
      (microsoft.public.vb.database.ado)
    • Re: Excel to Access and Access to Excel
      ... This code, connects to a Access database, sorts the contents of the ... excel sheet, & transfers the data to a table in the Access database. ... Dim objCommand As ADODB.Command ... ' open the recordset ...
      (microsoft.public.excel.programming)
    • Import Data from Access via DAO
      ... table tblSales has the following structure: ... It contains data for 200 Customers and each Customer has 4 records ... ' Select the MS Access Database that houses the data ... Dim DB As Database, RS As Recordset ...
      (microsoft.public.excel.programming)
    • Re: Excel to Access and Access to Excel
      ... This code, connects to a Access database, sorts the contents of the ... excel sheet, & transfers the data to a table in the Access database. ... Public Function Databaseconnect() ... ' open the recordset ...
      (microsoft.public.excel.programming)
    • Use ADO to add or update date in Access
      ... I have an employee evaluation form in Excel. ... The primary key name RACFID is located in cell A1, ... ' exports data from the active worksheet to a table in an Access database ... ' open a recordset ...
      (microsoft.public.excel.programming)