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

**URL:** <https://community.dreamfactory.com/t/microsoft-odbc-driver-11-for-sql-server-sql-server-cannot-update-identity-column-id/2179>\
**Category:** Connecting to SQL\
**Created:** [February 12, 2016, 8:15pm UTC](https://community.dreamfactory.com/t/microsoft-odbc-driver-11-for-sql-server-sql-server-cannot-update-identity-column-id/2179 "2016-02-12T20:15:54Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mharvey](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/mharvey/32/590_2.png) [@mharvey](https://community.dreamfactory.com/u/mharvey)\
**Post date:** [February 12, 2016, 8:15pm UTC](https://community.dreamfactory.com/t/microsoft-odbc-driver-11-for-sql-server-sql-server-cannot-update-identity-column-id/2179/1 "2016-02-12T20:15:54Z")

</div>

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?