Hi All;

I?m trying to build an application VERY similar (ok, so I?m copying it) to 
the one in Chap 15 of WROX ?Beginning ASP 3.0?  When I try to run I get 
the following error:

Microsoft JET Database Engine error '80040e09' Cannot update. Database or 
object is read-only.

Using the web download I put the exact files and db from the book on our 
server and get the exact same error.

After looking around and reading a bit I found that putting the database 
in the cgi-bin folder on our web server solves the problem, everything 
works as expected.  It seems that MS ACCESS needs to write a temp file in 
the process.

So everything works, but I want to understand what?s going on.  I thought 
using CGI added a level of interaction to the client/server process and 
that this was one of the advantages to using ADO with OLE-DB.

Any ideas, comments, or suggested readings (I haven?t yet finished the 
above mentioned book)?

Thanks for the help

Hi dear:
Sorry, but I have the same problem as u do, did u solve ur problem?!
if so please tell me how?!

Thanks in advance,
Hovik.


Did 
> Hi All;

> I?m trying to build an application VERY similar (ok, so I?m copying it) 
to 
t> he one in Chap 15 of WROX ?Beginning ASP 3.0?  When I try to run I get 
t> he following error:

> Microsoft JET Database Engine error '80040e09' Cannot update. Database 
or 
o> bject is read-only.

> Using the web download I put the exact files and db from the book on our 
s> erver and get the exact same error.

> After looking around and reading a bit I found that putting the database 
i> n the cgi-bin folder on our web server solves the problem, everything 
w> orks as expected.  It seems that MS ACCESS needs to write a temp file 
in 
t> he process.

> So everything works, but I want to understand what?s going on.  I 
thought 
u> sing CGI added a level of interaction to the client/server process and 
t> hat this was one of the advantages to using ADO with OLE-DB.

> Any ideas, comments, or suggested readings (I haven?t yet finished the 
a> bove mentioned book)?

> Thanks for the help

Hi;

The problem is solved in that the app works as long as I put the database 
in the server cgi-bin folder.

However, the book doesn?t mention this; using cgi adds a level of 
indirection to the client-server interaction.  The whole idea of using ado 
w/ole-db is to overcome this (speed things up).  So, is this a cgi process 
or is it a need of ms-access to write a temp file?

I guess I just find it hard to believe that for these types of apps to 
work all the db?s have to go in the same single folder on the server.

If I come across anything I?ll let you know.
Joe


> Hi dear:
S> orry, but I have the same problem as u do, did u solve ur problem?!
i> f so please tell me how?!

> Thanks in advance,
H> ovik.

> 
D> id 
>>  Hi All;

> > I?m trying to build an application VERY similar (ok, so I?m copying 
it) 
t> o 
t> > he one in Chap 15 of WROX ?Beginning ASP 3.0?  When I try to run I 
get 
t> > he following error:

> > Microsoft JET Database Engine error '80040e09' Cannot update. Database 
o> r 
o> > bject is read-only.

> > Using the web download I put the exact files and db from the book on 
our 
s> > erver and get the exact same error.

> > After looking around and reading a bit I found that putting the 
database 
i> > n the cgi-bin folder on our web server solves the problem, everything 
w> > orks as expected.  It seems that MS ACCESS needs to write a temp file 
i> n 
t> > he process.

> > So everything works, but I want to understand what?s going on.  I 
t> hought 
u> > sing CGI added a level of interaction to the client/server process 
and 
t> > hat this was one of the advantages to using ADO with OLE-DB.

> > Any ideas, comments, or suggested readings (I haven?t yet finished the 
a> > bove mentioned book)?

> > Thanks for the help

The problem is that the IUSR_<machine name> account needs write access to 
the folder that the .mdb file is in so that it can create the .ldb file 
when the database is open.

Shawn

> Hi;

> The problem is solved in that the app works as long as I put the 
database 
i> n the server cgi-bin folder.

> However, the book doesn?t mention this; using cgi adds a level of 
i> ndirection to the client-server interaction.  The whole idea of using 
ado 
w> /ole-db is to overcome this (speed things up).  So, is this a cgi 
process 
o> r is it a need of ms-access to write a temp file?

> I guess I just find it hard to believe that for these types of apps to 
w> ork all the db?s have to go in the same single folder on the server.

> If I come across anything I?ll let you know.
J> oe

> 
>>  Hi dear:
S> > orry, but I have the same problem as u do, did u solve ur problem?!
i> > f so please tell me how?!

> > Thanks in advance,
H> > ovik.

> > 
D> > id 
>> >  Hi All;

> > > I?m trying to build an application VERY similar (ok, so I?m copying 
i> t) 
t> > o 
t> > > he one in Chap 15 of WROX ?Beginning ASP 3.0?  When I try to run I 
g> et 
t> > > he following error:

> > > Microsoft JET Database Engine error '80040e09' Cannot update. 
Database 
o> > r 
o> > > bject is read-only.

> > > Using the web download I put the exact files and db from the book 
on 
o> ur 
s> > > erver and get the exact same error.

> > > After looking around and reading a bit I found that putting the 
d> atabase 
i> > > n the cgi-bin folder on our web server solves the problem, 
everything 
w> > > orks as expected.  It seems that MS ACCESS needs to write a temp 
file 
i> > n 
t> > > he process.

> > > So everything works, but I want to understand what?s going on.  I 
t> > hought 
u> > > sing CGI added a level of interaction to the client/server process 
a> nd 
t> > > hat this was one of the advantages to using ADO with OLE-DB.

> > > Any ideas, comments, or suggested readings (I haven?t yet finished 
the 
a> > > bove mentioned book)?

> > > Thanks for the help

Yes. You are right, I was gonna say the same thing...

> The problem is that the IUSR_<machine name> account needs write access 
to 
t> he folder that the .mdb file is in so that it can create the .ldb file 
w> hen the database is open.

> Shawn