Error: "insufficient key column information for updating or refreshing"

[Pedro de la Lastra]

Anybody know what that mean?

Thanks in Advance

[JHausmann]

In ADO it means examine your cursor choice.

[Clunietp]

Are you trying to update a recordset that is based off of a join query?

[DrewDog_21]

If you are using ADO, it also can mean that you did not include the primary key in your recordset. You have to include the primary key field in an ADO recordset that you want to update, otherwise it will not update correctly.

[sanon]

You insert data more or less of existing fields in DB. The safe way to insert a new record is specify what field you need to insert. For example:
In the DB there are:
id, name, nickname, address
but you need to insert only id, name, and address in some cases.
insert into table_name (id,name,address) values(...bla..bla..)