OLE to ODBC connections...

[Ross]

Hello everybody,

I am trying to convert an OLE access database to a ODBC connection.
When I first start out trying to configure the odbcdataadapter it tells me
that it cannot generate a delete or update statement because it cannot
uniquely identify the rows. It is using the same table as the OLE connection
and it does generate a update and delete statement. I checked the access
database table and found that I do have a primary key. I thought it might be
just the one specific table so I tried others from the same database and it
generates the same error. Am I missing something to do in the access table
or do I need to do something specific in ODBC connection????????

Thanks,
Ross