insufficient key column for updating and refreshing?

Question

i'm getting this error when i try to update my records... what does it mean and how could i solve this problem? please help.... (-;

it's on ms access....

sorry i don't know how to reply,
i do have set primary keys on table, i'm using adodc and set its recordsource to an sql statement, the adodc was connected to a query.... is that helpful? please help

Answer 1

what r u working with? sql server? ms access ?

Answer 2

Do you have a primary key set on the table?
Design View, have a field for primary key (ex. employeeID). Either use a unique number or use the data type Autonumber and New Values to Auto Increment.
Select Edit > Primary Key.

And, does the table you're updating have data in it?

(MSaccess 1 questions done :))

Have you set any Rs cursors?
rs.CursorLocation = adUseClient
rs.LockType = adLockBatchOptimistic