How do I add an Is Identity field with Identity Increment 1 and Identity Seed 1
It also needs to be set to the Primary Key
A working View exist that can be run from SSMS, Access (via SQL Server Native Client 11.0 Linked Tables), and Excel (via ODBC).
It just needs the first column with the identity (auto-counter) and for that to become the primary key.
It appears that the GIS ODBC driver requires a unique Primary Key.
The existing View can be consumed with ODBC or SQL Server Native Client 11.0 on Excel or Access.
But, when the GIS ODBC tries to link, the error Loading Table Data Attribute column not found[42S22] Invalid column name 'Well'.] appears.
However, the same GIS ODBC can successfully read other tables in the same SQL Server DB that have an Primary Key identity field.
In the past when GIS was consuming an Access DB, it wouldn't work until an autocounter Primary Key was added to the table.