Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_database_setup thread: Re: Access read-only error


Message #1 by "David Braun" <DAVID.BRAUN@o...> on Mon, 27 Aug 2001 18:55:50
> 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.






  Return to Index