AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Friday, August 31, 2007

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: ,

4 Comments:

Anonymous Anonymous said...

Thank you Alex! I've been struggling with this until I read your post.

Tom Wheatley
USA

1:27 AM  
Anonymous Anonymous said...

Perfection!!!
Thanks Alex

Grzegorz Zak
Poland

1:58 PM  
Anonymous Anonymous said...

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

3:41 PM  
Blogger it has said...

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

8:01 PM  

Post a Comment

<< Home