In the Visual Studio dataset designer, in a specific table, I added an expression to my SQL statement, just to get only part of a string
SELECT soumissionNumber, sDate, sClient, sProjet, sMandat, sClientId, mid(soumissionNumber, 9, 11) AS Expr1
Once I did this I can't update,save or delete records in the table anymore, I get the following error: Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.
My database is an access database
Thanks for the help!