Hi !

I Create a simple data form using SqlDataAdapter to connect to the users table.

It works if I connect to the users table itself - Great BUT...

If I do the same to connect to a view of the table I get the following error message when configuring the dataAdapter:

Generated UPDATE statement.
Could not determine which columns uniquely identify the rows for "v_AB6_IPs"

Generated DELETE statement.
Could not determine which columns uniquely identify the rows for "v_AB6_IPs"

Very simple View select which DOES include the primary key !

The primary key is the UserID, it is unique and does NOT allow Null values.

Are views not audatable this way ?

Thanks,

Pierre