Hi
I have a datadrid on my form and that links to a database as follows.
dim strID
strID=13
Adodc1.CommandType = adCmdUnknown
Adodc1.ConnectionString = cnBCD="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\ASF.mdb"
Adodc1.RecordSource = "SELECT hdd,C1,y0,y1,y2,y3,y4,y5,y6,y7,y8,y9,y10,y11,y12,y13,y14,y15 FROM NPC WHERE BCID=" & strID
Adodc1.Refresh
When I edit the data, program displays this error message Key column information is insufficent or incorrect. Too many rows were affected by update.
this happen when I leave some fields blank, and move on to another row?
Can anyone tell me how to correct this?
Thanks
I have a datadrid on my form and that links to a database as follows.
dim strID
strID=13
Adodc1.CommandType = adCmdUnknown
Adodc1.ConnectionString = cnBCD="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\ASF.mdb"
Adodc1.RecordSource = "SELECT hdd,C1,y0,y1,y2,y3,y4,y5,y6,y7,y8,y9,y10,y11,y12,y13,y14,y15 FROM NPC WHERE BCID=" & strID
Adodc1.Refresh
When I edit the data, program displays this error message Key column information is insufficent or incorrect. Too many rows were affected by update.
this happen when I leave some fields blank, and move on to another row?
Can anyone tell me how to correct this?
Thanks
