this is the error i have...

key column information is insufficient or incorrect. to many rows were affected by update.


thx for viewing...

hi my friend... this my saverecord procedure...

Sub saverecord()

rssupplier.AddNew
rssupplier.Fields("CompanyCode") = txt1.Text
rssupplier.Fields("CompanyName") = txt2.Text
rssupplier.Fields("ContactPerson") = txt3.Text
rssupplier.Fields("Position") = txt4.Text
rssupplier.Fields("TelephoneNo") = txt5.Text
rssupplier.Fields("Address") = txt6.Text
rssupplier.Update

End Sub


thxxxxxxxxx...

after an 2hour nothing have been change in my form..pls help

after i save a record the data was been save.
but when i end the run..
and run again the program..
the datagrid became null..

the record that i save was lost and only white lines left..
after i enter the command button continuesly the error appeared.

plssssssss plssssssss.......... somebody help me.........

"key column information is insufficient or incorrect" error appears to suggest that your primary key field (whatever that may be) has either been left empty, or the contents of it is the same as a record already in your database.

Edit: on a google search, it is possible you have not included the Primary Key field in your recordset. This can also cause a similar error.

Please try to look again in your datagrid maybe you missed about the name of the fields, may you lack in declaring some fields.

and about your code update...

rssupplier.AddNew
rssupplier.Fields("CompanyCode") = txt1.Text
rssupplier.Fields("CompanyName") = txt2.Text
rssupplier.Fields("ContactPerson") = txt3.Text
rssupplier.Fields("Position") = txt4.Text
rssupplier.Fields("TelephoneNo") = txt5.Text
rssupplier.Fields("Address") = txt6.Text
rssupplier.Update

I dnt see any rpoblem here but if this cause a problem then review your fieldnames.
1. how many fieldnames.
2. spelling of the fieldnames...

hope this will help you...

thxxxx for the reply thxx alot when i solved this i will give to all of you a reputation. heheh^_^

i already check my table field but its all the same.

could somebody give me a site on error detection?
i will check it.
plsssssss give me any idea.. ]


thxxxxx .. thxxxxxxxxx

This question has already been answered. Start a new discussion instead.