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

Saturday, August 11, 2007

How to Recover from Suspect Database

Useful post:
PHOENIX: How to Recover from Suspect Database

Friday, August 03, 2007

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