[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot update identity column 'Id'


#1

Trying to edit a record in the data tab in admin I get the following error:

[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot update identity column ‘Id’

I read about a similar issues elsewhere using this driver where the driver didn’t know how to handle identity columns and that I explicitly need to insert the columns only. Does this mean editing the data in the UI won’t work on tables where there are primary keys?