How to make linked SQL Server view updateable
If you link SQL Server view using Access interface, then Access asks you to select a unique index in order to make new linked table updatable. But once you relink table using code – its again becomes read-only. How to add unique index? DDL will help here, just run the following code:
Currentdb.Execute "CREATE UNIQUE INDEX PK ON VIEW1 (ID)"
Where ID – is a unique field, can be list of fields