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

How to Recover from Suspect Database

Useful post:
PHOENIX: How to Recover from Suspect Database

ViewONE, ASP.NET and authorization

This is not an Access related post, but hopefully would be helpful for somebody. I have built an ASP.NET application with ViewONE java image viewer, which supports annotations – user can add arrows, lines, comment on image and save this, in separate file or database. And one day these annotations stopped working, viewer showed java error "Annotation data is not in the required format", while format was certainly correct. This error occurred in IE7, while in IE6 worked fine. The problem was (I guess) that ASP.NET adds some authorization info to annotations file, and viewer interprets this incorrectly. So the trick is to turn off authorization for such annotation file in web.config:

<location path="AnnOpen.aspx">
  <system.web>
    <authorization>
      <allow users="*,?" />
    </authorization>
  </system.web>
</location>

Technorati tags: ASP.NET, applet, java, ViewONE