RE: -2147217864 Row cannot be located for updating.

From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 12/28/04 

Date: Tue, 28 Dec 2004 03:21:33 GMT

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."