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

 

Technorati tags: Linked View, DDL