IE mailmerge application recieving "Access Denied" under Win XP SP

From: Thomas Bushman (ThomasBushman_at_discussions.microsoft.com)
Date: 03/01/05


Date: Tue, 1 Mar 2005 06:03:14 -0800

Due to formatting requirements for a document that our corporation wanted
automated, I wrote a intranet application which does mail merge with the
database to produce the form (the users need to be able to also edit the data
in the form before they print out).

The way I did this was I had an ASP page that was mainly client code. I had
a server side VBScript block which accessed the database, got the data needed
for the form, and then wrote out a dynamic client side block which set
variables. I next had a client side block which using a Word object opened
the template for the form, and then updated the bookmarks in the form with
the values of the variables. It then saved that document onto the local
filesystem and then response.redirected to that file. The application worked
flawlessly until SP2. Now I get an access denied on the response.redirect to
the file on the local filesystem. I presume this is due to the lock down of
the local filesystem with SP2, but the ironic thing is I can WRITE the file
out to the filesystem, I just can't browse to it. I have tried various
different things such as opening the document in a new window, etc. No matter
what I do, I can't view the file under the browser session that created the
file (but if I open another IE browser window and enter the URL of the file I
can see it then).

Is there a way to turn off the local filesystem lockdown, since I presume
this is what is causing my problem? Or does anyone have any other
recommendations?

FYI: I do realize there are a couple other solutions. One would be to create
the document on the web server, but our IT group has said no to having IIS
and Office on the same server, and even Microsoft has said that is a security
risk. If the personal web server is turned on for each client and I opened
via http://localhost that does work, however our IT folks have also said no
to that, since running personal IIS on each workstation is also considered a
security risk. Turning off the local machine lockdown seems to be my only
solution to this problem I have, but so far we haven't been able to figure
out how to do that.



Relevant Pages

  • Re: Help with first VB application - Data Entry form
    ... I assumed a desktop / winform client application ... time' stamp from the database machine - control machine ... ... problem solved - web server is control system. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Help with first VB application - Data Entry form
    ... I assumed a desktop / winform client application ... time' stamp from the database machine - control machine ... ... problem solved - web server is control system. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Help with first VB application - Data Entry form
    ... stamp from the database machine - control machine ... ... unnecessary data to the client ... ... and when building a database independent UI / Client - Server application, ... JavaScript, for example) and thus, will get the time from the web server, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Re: Can we use DAPs to access remote MDB files?
    ... the server and the user will not know it's happening. ... web server (from the client) and others seem to be saying it's NOT ... multi-user database pretty well straight out of the box. ...
    (comp.databases.ms-access)
  • Re: Help with first VB application - Data Entry form
    ... JavaScript, for example) and thus, will get the time from the web server, ... function on the client. ... the database is not the place to put a time stamp of this ...
    (microsoft.public.dotnet.languages.vb)

Quantcast