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

3 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  

Post a Comment

Links to this post:

Create a Link

<< Home