|
 |
asp_databases thread: IUSR settings to allow read/write access using ASP
Message #1 by "Garth Stewart" <garthe@q...> on Fri, 20 Jul 2001 09:15:27 -0700
|
|
How does one set up the IUSR account to allow full access to a database and
file using ASP? I have been getting this error:
Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/The_Site/WROX_Press/Ch14/AddNew.asp, line 21
and I suspect it is b/c my IUSR settings are incorrect. Anyone at all?
Thanks.
Garth
Message #2 by "Tomm Matthis" <matthis@b...> on Fri, 20 Jul 2001 16:40:55 -0400
|
|
The IUSR_xxx account needs to have create/delete access to the
directory/folder where the .MDB resides. It needs this in order to
create/delete the lock (.LDB) file.
-- Tomm
> -----Original Message-----
> From: Garth Stewart [mailto:garthe@q...]
> Sent: Friday, July 20, 2001 12:15 PM
> To: ASP Databases
> Subject: [asp_databases] IUSR settings to allow read/write access
using
> ASP
>
>
> How does one set up the IUSR account to allow full access to a
> database and
> file using ASP? I have been getting this error:
>
> Error Type:
> Microsoft JET Database Engine (0x80040E09)
> Cannot update. Database or object is read-only.
> /The_Site/WROX_Press/Ch14/AddNew.asp, line 21
>
> and I suspect it is b/c my IUSR settings are incorrect. Anyone at
all?
>
> Thanks.
>
>
> Garth
>
Message #3 by "Grant I" <giswim1@a...> on Fri, 20 Jul 2001 20:41:13
|
|
On the server, navigate to the db's folder (should be separate from your
pages). Right click on the db's folder and select properties. Click the
security tab. Click the permissions button. Select the IUSR_whatever
account and select either full control, or special access and choose at
least read, write, and delete (this is so the server can make temp files
and delete them). Make sure that these settings will propogate to the
files in this folder.
I think that should do it for you... if anyone sees anything wrong with
what I've said, let us know :)
HTH
Grant
> How does one set up the IUSR account to allow full access to a database
and
> file using ASP? I have been getting this error:
>
> Error Type:
> Microsoft JET Database Engine (0x80040E09)
> Cannot update. Database or object is read-only.
> /The_Site/WROX_Press/Ch14/AddNew.asp, line 21
>
> and I suspect it is b/c my IUSR settings are incorrect. Anyone at all?
>
> Thanks.
>
>
> Garth
>
Message #4 by Syed Shakir Ali <aliss0a@a...> on Sat, 21 Jul 2001 00:57:49 +0300
|
|
You are absolutely correct. I have seen many messages in this regard
and
found your answer very correct.
Thanks.
----- Original Message -----
=46rom: "Grant I" <giswim1@a...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, July 20, 2001 11:41 PM
Subject: [asp_databases] Re: IUSR settings to allow read/write access
using
ASP
> On the server, navigate to the db's folder (should be separate from
your
> pages). Right click on the db's folder and select properties. Cli
ck the
> security tab. Click the permissions button. Select the IUSR_whate
ver
> account and select either full control, or special access and choos
e at
> least read, write, and delete (this is so the server can make temp
files
> and delete them). Make sure that these settings will propogate to
the
> files in this folder.
>
> I think that should do it for you... if anyone sees anything wrong
with
> what I've said, let us know :)
>
> HTH
> Grant
>
> > How does one set up the IUSR account to allow full access to a da
tabase
> and
> > file using ASP? I have been getting this error:
> >
> > Error Type:
> > Microsoft JET Database Engine (0x80040E09)
> > Cannot update. Database or object is read-only.
> > /The_Site/WROX_Press/Ch14/AddNew.asp, line 21
> >
> > and I suspect it is b/c my IUSR settings are incorrect. Anyone a
t all?
> >
> > Thanks.
> >
> >
> > Garth
> >
>
>
|
|
|
View Cart
