Hello All

I wonder if any one may help me resolve a small problem here. I am trying to get the configuration wizard to autogenerate the SQL for an Access 2000 database table. The problem is, in the last step of the configuration wizard's procedure, it tells me : "Could not determine which columns uniquely identify the rows for table".
This message is given regarding the update and delete SQL statements (which therefore did not get generated!). The wizard was able to generate SQL for the insert and SELECT SQL statements. My Access table is using the Autonumber datatype as a primary key. It seems that this should be enough for Access to know which columns uniquely identify the rows for my table! I am using the Configuration Wizard with odbcDataAdapter1.

Cmarek

__________________
Cmarek

I get the same - I am using Access 2000 also, and the OdbcDataAdapter.
The table has a single index - the Primary Key, which is an AutoNumber and the first field.

I've been looking all over for an answer, as you have. I'm guessing there is a bug in .NET, because any table I try this with gives me the same thing. If this is documented somewhere, I haven't seen it.

David

I had this problem and it was because I had a "." in the database name. Remove the period and it worked.

Had the same problem because I used OdbcDataAdapter for the connection. To connect to an Access db you need to use the OleDbAdapter instead by clicking on 'Provider' and then choosing Microsoft Jet 4.0, from there the steps are about the same for the rest of the Adapter.