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
posted by Alex Dybenko | 11:50
Copyright © 2016 Alex Dybenko
4 Comments:
Thank you Alex! I've been struggling with this until I read your post.
Tom Wheatley
USA
Perfection!!!
Thanks Alex
Grzegorz Zak
Poland
Thans a lot!! Spot on!!
I was wondering if I had to redesign my solution, but luckely, I found your blog, and your suggestion solved my issue.
Best regards,
Lorents Nord-Varhaug
Denmark
Great Article
Cyber Security Projects
projects for cse
Networking Security Projects
JavaScript Training in Chennai
JavaScript Training in Chennai
The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training
Post a Comment
<< Home