Wrox Home  
Search P2P Archive for: Go

  Return to Index  

ado_dotnet thread: IUSR_ Permissions? Changing on-the fly


Message #1 by "Andrew Peters" <apeters@h...> on Fri, 12 Apr 2002 13:47:43
I got ASP.NET SDK and tried my first database script.  Accessing the data 
went fine, but trying to update or make any changes to the database gave 
me errors.  After opening up my database (in Access), I received a 
message box saying that the database was now read-only.  I tried the 
following (hints from other posts, etc.):

1.  Turned replication off in the Access database
2.  Checked if IUSRL_ANDREWPERSONAL had write permission to both the 
directory and the file (in IIS)
3.  Checked the database file's properties in windows explorer to see if 
it was read-only.
4.  Checked the System DNS under the ODBC data source administrator to 
see if THAT was read-only.

I can't seem to figure out why the database was turned read-only AFTER I 
designed and saved it initially.  I even tried all over again to see if 
it was just a fluke and re-copied the database into my wwwroot/db/  

Any help on this would be greatly appreciated.  

Andrew Peters
apeters@h...
Message #2 by Imar Spaanjaars <Imar@S...> on Fri, 12 Apr 2002 17:32:17 +0200
Is it possible that the database is read-only on FILE level? For example, 
when e-mailing a database with Outlook, the database turns out to be read 
only when you save it.

Maybe too obvious, but you never know.

Imar


At 01:47 PM 4/12/2002 +0000, you wrote:
>I got ASP.NET SDK and tried my first database script.  Accessing the data
>went fine, but trying to update or make any changes to the database gave
>me errors.  After opening up my database (in Access), I received a
>message box saying that the database was now read-only.  I tried the
>following (hints from other posts, etc.):
>
>1.  Turned replication off in the Access database
>2.  Checked if IUSRL_ANDREWPERSONAL had write permission to both the
>directory and the file (in IIS)
>3.  Checked the database file's properties in windows explorer to see if
>it was read-only.
>4.  Checked the System DNS under the ODBC data source administrator to
>see if THAT was read-only.
>
>I can't seem to figure out why the database was turned read-only AFTER I
>designed and saved it initially.  I even tried all over again to see if
>it was just a fluke and re-copied the database into my wwwroot/db/
>
>Any help on this would be greatly appreciated.
>
>Andrew Peters
>apeters@h...



  Return to Index