Generated UPDATE statement. could not determine which columns uniquely ...

[somersbar]

hi all,
i am having trouble updating a datset because i get the follwing error
in the Data Adapter configuration Wizard:

Generated UPDATE statement. could not determine which columns uniquely
identify the rows for "Customers"


'Customers' is the only table from the database that im using for this
query, so it cant be anything to do with a problem of having multiple
tables. and the primary key is set. so i dont understand what the
problem is.


im using a microsoft access database, and an
OdbcDataAdapter.


can anyone help?

 

[somersbar]

and i also get a Generated DELETE statement error.

 

[Jamie Bissett]

Do you have the Primary Key in you're select statement ?

 

[somersbar]

ya.