Could not determine which columns uniquely identify the rows

[tsh]

Hello everybody,

When I try to configure my data adapter I get the error "Could
not determine which columns uniquely identify the rows for "Products"."
This is for my update and delete statements. I dont understand what is
wrong. I have a primary key in my Access database. What am I doing wrong?

 

[cjard]

sounds like you havent told the data set which field the primary key is..

please go to your profile and fill in what your primary platform is so we can give advice relevant to .net 1, 1.1 or 2

 

[tsh]

I'm using microsoft visual studio.net 2003.Can you teach me how to told the data set which field the primary key is? I though it should know automatically while i already set in access database?

 

[cjard]

mmh.. open your dataset and look at the datatable there.. right click on the particular column(s - use ctrl to multi select) that is the PK and choose Set Primary Key

note: this advice is for 2005, i dont know if this aspect of functionality is different in 2003