Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_database_setup thread: Re: Access read-only error


Message #1 by john.s@p... on Sun, 9 Sep 2001 16:28:21
> > i have created a site which uses the access file,

> > which is kept in the same directory with the other

> > .asp files, while retreiving the data, it works very

> > fine on the net, but when i try to insert,update or

> > delete records from any tables, it shows an error

> > 

> > Microsoft JET Database Engine error '80040e09' 

> > 

> > Cannot update. Database or object is read-only. 

> > 

> > pls help me out

> > 

> 

> This error can also be caused by having the Anonymous Browsing option 

> turned on in the Document Security section of web site properties in 

IIS.  

> By default, this is normally turned on but if you are trying to use 

NTFS 

> security to control access to the database or other information in the 

web 

> site files, you have to turn this option off.  What happens is that IIS 

> must be able to "impersonate" the client in order to test their access 

> privileges and in order to do that it must learn from IE what their NT 

> identity is.  That apparently doesn't work if Anonymous Browsing is 

turned 

> on.  So IIS plays it safe and denies access until it can be certain of 

the 

> users NT identity.

> 

> 



Check the NTFS permissions for this file to insure that the Everyone 

member has write permissions. If this does not resolve the issue, check 

the cursorType in your code just to make sure that you can update your 

datastore. Hope this helps you.



John

  Return to Index