Mike
I have tried this with sql 2000 and access and i was getting the error until
I set the primary key on the table to a column with unique values(ensure
that your column has unique values otherwise the primary key will not be
set. This column also has a setting which does not allow nulls.
Also once you have set the primary key, I would delete your connection from
server explorer in dot net, then re-establish your connection. Once you
have done this, place the table on to the form.
Hope it works!
Kuv Patel
"Mike B" <mp****@bellsouth.net> wrote in message
news:15****************************@phx.gbl...
I'm new to C# (standard edition). I was trying to work
with an Access detabase and a datagrid. When I drag a
table from the Server Explorer to my form, I am getting an
error generating UPDATE and DELETE commands ("could not
uniquely identify the rows for Table1"). I have a key
field defined in Access-what am I doing wrong?
Other than that it works OK (creating a dataset, linking
it to datagrid, etc.) in that I can display the records on
my form.
Thanks for any help,
Mike B