RE: -2147217864 Row cannot be located for updating.

From: Vineet (Vineet_at_newsgroup.nospam)
Date: 12/28/04 

Date: Tue, 28 Dec 2004 08:55:02 -0800

Hi Kevin,

Thanks for the help. Yes you understood my issue correctly, I am getting
error when I ass new record to the recordset.
I do have composite primary key and I am inserting new values to these
fields. I have checked all data and there is no discrepencies.

I also have MDAC 2.8 onmy machine.

Just for your info, this code is working on more than 100 projects in my
company from last 6-7 months. But suprisingly I am having this error just for
one particular project and for a particular data row. I have checked each and
every data field for this data row and found nothing wrong.
I am able to add 68 records to my recordset but it fails everytime at 69th
row.

Anyway, thanks again for your help, I guess I have to check the data at
microscopic level for this 69th row.

"Kevin Yu [MSFT]" wrote:

> Hi Vineet,
>
> First of all, I would like to confirm my understanding of your issue. From
> your description, I understand that you're getting an error when trying to
> add a new record in the Recordset object. If there is any misunderstanding,
> please feel free to let me know.
>
> Based on my research, this might be caused by some Primary Key issues.
> Could you please check if there is any PK conflicts when adding a new row?
> Is the PK an auto-number field? If so, I think we had better not assign
> value to this field. Just leave it, and the database will give it value.
>
> If that still doesn't work, please try to upgrade the MDAC to 2.8. It can
> be downloaded from the following link:
>
> http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-
> b037-185d0506396c&DisplayLang=en
>
> You can also check the following links for more information:
>
> http://support.microsoft.com/?id=300586
>
> http://groups.google.com/groups?hl=zh-CN&lr=&threadm=eyFqw6muBHA.2712%40tkms
> ftngp05&rnum=2&prev=/groups%3Fq%3D2147217864%2B%2522Row%2Bcannot%2Bbe%2Bloca
> ted%2Bfor%2Bupdating%2522%2Baddnew%26hl%3Dzh-CN%26lr%3D%26selm%3DeyFqw6muBHA
> .2712%2540tkmsftngp05%26rnum%3D2
>
> http://groups.google.com/groups?hl=zh-CN&lr=&threadm=%23DrGa7%247%24GA.218%4
> 0cppssbbsa02.microsoft.com&rnum=10&prev=/groups%3Fq%3D2147217864%2B%2522Row%
> 2Bcannot%2Bbe%2Blocated%2Bfor%2Bupdating%2522%2Baddnew%26hl%3Dzh-CN%26lr%3D%
> 26selm%3D%2523DrGa7%25247%2524GA.218%2540cppssbbsa02.microsoft.com%26rnum%3D
> 10
>
> http://groups.google.com/groups?hl=zh-CN&lr=&threadm=OAKA9XZ4AHA.1924%40tkms
> ftngp07&rnum=14&prev=/groups%3Fq%3D2147217864%2B%2522Row%2Bcannot%2Bbe%2Bloc
> ated%2Bfor%2Bupdating%2522%2Baddnew%26start%3D10%26hl%3Dzh-CN%26lr%3D%26selm
> %3DOAKA9XZ4AHA.1924%2540tkmsftngp07%26rnum%3D14
>
> Kevin Yu
> =======
> "This posting is provided "AS IS" with no warranties, and confers no
> rights."
>
>

Relevant Pages

  • RE: Code to Update Recordset only works intermittently
    ... A server-side cursor must be used for the Recordset. ... See http://www.QBuilt.com for all your database needs. ... > that the reference to the index is set differently and the primary key in ... > Dim cnn As ADODB.Connection ...
    (microsoft.public.access.modulesdaovba)
  • RE: Deleting a record deletes item from combo boxs underlying tab
    ... You changed the primary key for one of the tables - I know I'm stating the ... I would be concerned that the form's recordset type is Dynaset (inconsistent ... can you post the SQL of the query underlying the form? ... The forms recordset type is Dynaset ...
    (microsoft.public.access.formscoding)
  • RE: Code to Update Recordset only works intermittently
    ... Thank you for responding. ... A server-side cursor must be used for the Recordset. ... > See http://www.QBuilt.com for all your database needs. ... >> that the reference to the index is set differently and the primary key in ...
    (microsoft.public.access.modulesdaovba)
  • Re: Help needed with ADO Update
    ... No primary key on the tablereferenced. ... I've only ever seen that message when trying to update a recordset ... SQL statement was valid via the response.write test prior to executing the ... I read the reference materials from Bob's pointer re: ...
    (microsoft.public.data.ado)
  • Re: Database Structure Question ... Serious Help Only Pls
    ... Maybe simply appending with a query won't work... ... The only problem you might have is determining the primary key ... On your recordset object after you have updated the recordset issue a ... it, and append the parent table data, grab the PK as above and store it ...
    (comp.databases.ms-access)