When updating recordset I get error -2147467259 (Insufficient or incorrect
key column information; to many rows affected by update)

Help

I am developing a webclass that passes about 200 records from an online form
to a access97 database.

Upon "recordset.update" I get the error above.

Pseude Code
with recordset
    if state=0 then .open
    do while not .eof
        x=x+1
        !Field1=request("String"& x)
        !Field2=request("String"& x)
        !Field3=request("String"& x)
        .update            <-----------------ERROR -2147467259
        .movenext
    loop
    if .state=1 then .close
end with

If you have any indexes defined in you table you must include those
fields in your select statement, otherwise the recordset becomes
confused and is unable to update the record(s). For Example:

"Select X1, X2, A1, A2 From table"
where X1 and X2 are indexed
do while not rs.eof
  rs.A1 = "111"
  rs.A2 = "222"
  rs.update
  rs.movenext
loop

If you don't include X1 and X2 you'll get the error.