I have a group of ASP scripts that have been working great, running as a 

sub-web of my State's main web server. The data center wants all the 

sub-webs gone and is moving the various agencies to their own virtual web 

servers (e.g. from www.state.xx.us/agency to www.agency.state.xx.us/).



The ASP scripts are in one directory, and the MDB files are in a data 

directory below that. On the new server, I cannot update or add records to 

the database, although reads work fine. The server admin checked the 

permissions and said they were fine.  We eventually debugged the problem to 

the fact that, under IIS 4.0 my agency's web process is set to "run in 

separate memory space (isolated process)." If she removes that, the scripts 

run. When she restores that setting, they fail with the following error:



- - - - - - - - - - - - - - -

Microsoft OLE DB Provider for ODBC Drivers error '80004005'



[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object 

is read-only.



/local_health/DOHSurvey2001Personnel.asp, line 171

- - - - - - - - - - - - - - -



The MS Knowledgebase has a LOT to say about this error, but doesn't have a 

specific entry for "Database or object is read-only" and the other sections 

don't necessarily seem to apply.



The server admin claims that the scripts are flagged read/executable and 

that the guest account has read/write/create/delete permissions in the data 

directory.



Does anyone know what might be going on?



Thanks,

Ken Mosher

I'm answering my own question so others might benefit from the experience.



The web server administrator called me back with a solution. Apparently when you create a 

virtual web server and set it to run in its own memory space, it creates an object in Microsoft 

Transaction Server, a transaction Package, that uses the IWAM user (as opposed to the IUSR 

user).  As soon as she gave the IWAM user the necessary rights my application started 

working again.



-Ken



> I have a group of ASP scripts that have been working great, running as a 

> sub-web of my State's main web server. The data center wants all the 

> sub-webs gone and is moving the various agencies to their own virtual web 

> servers (e.g. from www.state.xx.us/agency to www.agency.state.xx.us/).

> 

> The ASP scripts are in one directory, and the MDB files are in a data 

> directory below that. On the new server, I cannot update or add records 

to 

> the database, although reads work fine. The server admin checked the 

> permissions and said they were fine.  We eventually debugged the problem 

to 

> the fact that, under IIS 4.0 my agency's web process is set to "run in 

> separate memory space (isolated process)." If she removes that, the 

scripts 

> run. When she restores that setting, they fail with the following error:

> 

> - - - - - - - - - - - - - - -

> Microsoft OLE DB Provider for ODBC Drivers error '80004005'

> 

> [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or 

object 

> is read-only.

> 

> /local_health/DOHSurvey2001Personnel.asp, line 171

> - - - - - - - - - - - - - - -

> 

> The MS Knowledgebase has a LOT to say about this error, but doesn't have 

a 

> specific entry for "Database or object is read-only" and the other 

sections 

> don't necessarily seem to apply.

> 

> The server admin claims that the scripts are flagged read/executable and 

> that the guest account has read/write/create/delete permissions in the 

data 

> directory.

> 

> Does anyone know what might be going on?

> 

> Thanks,

> Ken Mosher