Re: READ ONLY!!!
From: Roger Abell [MVP] (mvpNOSPAM@asu.edu)
Date: 12/18/02
- Next message: eric: "taken ownership"
- Previous message: Roger Abell [MVP]: "Re: Q324929"
- In reply to: Doug Knox MS-MVP: "Re: READ ONLY!!!"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Roger Abell [MVP]" <mvpNOSPAM@asu.edu> Date: Tue, 17 Dec 2002 23:21:05 -0700
Hi Doug,
Sure, and that is how it should be done, storing the mdb
outside of the web content area. However, this is not very
handy without server access, and so they often are within
the vdir of the web content. When this is so, then both
the NTFS permissions and the IIS metabase need to be
set to allow write. It was this that I was posting to clarify
for Stephan, since often when one just has a web hosted
on a server the mdb is published just like the other content.
-- Roger "Doug Knox MS-MVP" <dknox@mvps.org> wrote in message news:Odj62XgpCHA.1948@TK2MSFTNGP10... Roger, I'm running a similar web site, and for security purposes, the MDB file, nor its folder, is not part of the virtual directory of the web site. But I did give the IUSR account write level access, via standard file permissions, and internet users can update the database with no problems. -- Doug Knox, MS-MVP Windows XP/9x Win 95/98/Me/XP Tweaks and Fixes http://www.dougknox.com -------------------------------- Associate Expert ExpertZone - http://www.microsoft.com/windowsxp/expertzone -------------------------------- Please reply only to the newsgroup so all may benefit. Unsolicited e-mail is not answered. "Roger Abell [MVP]" <mvpNOSPAM@asu.edu> wrote in message news:#s9q8kdpCHA.2308@TK2MSFTNGP10... > "Doug Knox MS-MVP" <dknox@mvps.org> wrote in message > news:unO0mHZpCHA.1996@TK2MSFTNGP12... > Did you give your IUSR_(Machinename) account write privileges for the folder > the database resides in? > > -- > Doug Knox, MS-MVP Windows XP/9x > Win 95/98/Me/XP Tweaks and Fixes > http://www.dougknox.com > -------------------------------- > Associate Expert > ExpertZone - http://www.microsoft.com/windowsxp/expertzone > > > > And also did you make sure that if the folder where the > mdb is stored is within the web vdir, then it needs to > have the write option on within the IIS mgmt interface. > > -- > Roger Abell > MS MVP (Security, Windows), MCDBA, MCSE both > Associate Expert - Windows XP ExpertZone > http://www.microsoft.com/windowsxp/expertzone > > > "Stephen McCormack" <smacca@hotmail.com> wrote in message > news:0a0001c2a58a$c07a8500$8ef82ecf@TK2MSFTNGXA04... > > All new files are created as READ-ONLY and I cannot > > remove this attribute. This is extremely annoying!! > > > > More specifically, I am trying to update a database using > > ASP code on a webpage but because the folder where the > > database resides and database file itself are read-only, > > I cannot execute my code. The following message is > > returned. > > > > > > "Must be an updateable query" > > > > NOTE: I get this message when trying to execute in MS > > Access 2000 itself > >
- Next message: eric: "taken ownership"
- Previous message: Roger Abell [MVP]: "Re: Q324929"
- In reply to: Doug Knox MS-MVP: "Re: READ ONLY!!!"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
