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

  • Thread starter Thread starter bazzer
  • Start date Start date
B

bazzer

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 asp.net 2003, a microsoft access database, and an
OdbcDataAdapter.

can anyone help?
 
ive tried linking to a database with only one table, that has 2 fields,
'numbers', and 'names', set the primary key to numbers, and still it
wont work. ive even tried using windows forms and still i get the same
errors.
 
your suggestion? checking if the primary key is set, and checking for
duplicate values?

primary key is definetly set. and its set to Autonumber. By duplicate
values do you mean duplicate fields or primary keys. but as i said, ive
tried linking to a database with only one table, that has only 2
fields, 'numbers', and 'names', set the primary key to numbers, and
still it
wont work even with the most basic table. ive even tried using windows
forms and still i get the same errors. im about ready to give up really
cause no one seems to have a clue whats wrong. myself included. i can
only assume its something to do with the connection to the database
maybe. thanks for the help though. if u think of anything else let me
know.
 
Weird. Perhaps create a brand new database and try there? Perhaps it's
corrupted?

Jeff
 
I did see this from a Google search

If I switch to OleDbConnection instead of OdbcConnection, everything's ok.
 
Back
Top