ODBC DataAdapter error when automaticaly generating UPDATE and DELETE command for Access database
Posted on 2003-11-14
Why can't ODBC data adapter automaticaly generate UPDATE and DELETE commands for Access database? The error message (warning) is "Could not determine which columns uniquely identify the rows for "MyTable".".
I defined the primary key column in my Access database like this:
Primary Key: Yes
Data Type: AutoNumber
New Values: Increment
Indexed: Yes (No Duplicates)
How can I define these commands myself? Could anyone clarify to me the usage of parameters with commands?