Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: Error : Database or object is read-only


Message #1 by "Graham Abrey" <design@t...> on Sun, 20 Jan 2002 22:52:04
What does the following error mean:-



Error Type:

Microsoft JET Database Engine (0x80040E09)

Cannot update. Database or object is read-only.

/efreelancer/guest/addemail.asp, line 75



I can make my pages read from the Db but not write to them.

How can I go about correcting this problem.



Thanks,

Graham
Message #2 by Thomas Bellavia <TBellavia@V...> on Wed, 23 Jan 2002 09:21:39 -0500
It meqans the database is a read only file...



-----Original Message-----

From: Graham Abrey [mailto:design@t...]

Sent: Sunday, January 20, 2002 5:52 PM

To: Access ASP

Subject: [access_asp] Error : Database or object is read-only





What does the following error mean:-



Error Type:

Microsoft JET Database Engine (0x80040E09)

Cannot update. Database or object is read-only.

/efreelancer/guest/addemail.asp, line 75



I can make my pages read from the Db but not write to them.

How can I go about correcting this problem.



Thanks,

Graham




Message #3 by "Pritesh_b" <pritesh_b@t...> on Wed, 23 Jan 2002 15:12:37 -0000
Hi



I am not sure if this will help you however i had a similar problem and i

found that i did not have write permissions on the directory where the

database was stored and on the database file itself.



Thanks



Pritesh

----- Original Message -----

From: "Thomas Bellavia" <TBellavia@V...>

To: "Access ASP" <access_asp@p...>

Sent: Wednesday, January 23, 2002 2:21 PM

Subject: [access_asp] RE: Error : Database or object is read-only





> It meqans the database is a read only file...

>

> -----Original Message-----

> From: Graham Abrey [mailto:design@t...]

> Sent: Sunday, January 20, 2002 5:52 PM

> To: Access ASP

> Subject: [access_asp] Error : Database or object is read-only

>

>

> What does the following error mean:-

>

> Error Type:

> Microsoft JET Database Engine (0x80040E09)

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

> /efreelancer/guest/addemail.asp, line 75

>

> I can make my pages read from the Db but not write to them.

> How can I go about correcting this problem.

>

> Thanks,

> Graham




$subst('Email.Unsub').

>




$subst('Email.Unsub').



Message #4 by "Peter Rooney" <peter.rooney@p...> on Wed, 23 Jan 2002 17:59:46 -0000

Also right click on your db and check that it's not set to read only



-----Original Message-----

From: Pritesh_b [mailto:pritesh_b@t...]

Sent: Wednesday, January 23, 2002 3:13 PM

To: Access ASP

Subject: [access_asp] RE: Error : Database or object is read-only







Hi



I am not sure if this will help you however i had a similar problem and i

found that i did not have write permissions on the directory where the

database was stored and on the database file itself.



Thanks



Pritesh

----- Original Message -----

From: "Thomas Bellavia" <TBellavia@V...>

To: "Access ASP" <access_asp@p...>

Sent: Wednesday, January 23, 2002 2:21 PM

Subject: [access_asp] RE: Error : Database or object is read-only





> It meqans the database is a read only file...

>

> -----Original Message-----

> From: Graham Abrey [mailto:design@t...]

> Sent: Sunday, January 20, 2002 5:52 PM

> To: Access ASP

> Subject: [access_asp] Error : Database or object is read-only

>

>

> What does the following error mean:-

>

> Error Type:

> Microsoft JET Database Engine (0x80040E09)

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

> /efreelancer/guest/addemail.asp, line 75

>

> I can make my pages read from the Db but not write to them.

> How can I go about correcting this problem.

>

> Thanks,

> Graham




$subst('Email.Unsub').

>




$subst('Email.Unsub').








-- 

Virus scanned by edNET.

Message #5 by "Graham Abrey" <design@t...> on Wed, 23 Jan 2002 18:56:47
Thanks all, but you are absolutely right. The folder in which the DB sits 

is read-only but the DB is fine because its writable (not read-only). The 

problem is the folder in which he DB sits. I have tried numerous ways in 

trying to change the folders status (using folder properties> switch off 

read-only) but when re-checking the folder status it reverts back to read-

only. Is there a way in order to switch off the folder-read-only status 

permanently? I have even tried creating a brand new folder, but with no 

luck.



Thanks Graham



 



> Also right click on your db and check that it's not set to read only

> 

> -----Original Message-----

> From: Pritesh_b [mailto:pritesh_b@t...]

> Sent: Wednesday, January 23, 2002 3:13 PM

> To: Access ASP

> Subject: [access_asp] RE: Error : Database or object is read-only

> 

> 

> 

> Hi

> 

> I am not sure if this will help you however i had a similar problem and 

i

> found that i did not have write permissions on the directory where the

> database was stored and on the database file itself.

> 

> Thanks

> 

> Pritesh

> ----- Original Message -----

> From: "Thomas Bellavia" <TBellavia@V...>

> To: "Access ASP" <access_asp@p...>

> Sent: Wednesday, January 23, 2002 2:21 PM

> Subject: [access_asp] RE: Error : Database or object is read-only

> 

> 

> > It meqans the database is a read only file...

> >

> > -----Original Message-----

> > From: Graham Abrey [mailto:design@t...]

> > Sent: Sunday, January 20, 2002 5:52 PM

> > To: Access ASP

> > Subject: [access_asp] Error : Database or object is read-only

> >

> >

> > What does the following error mean:-

> >

> > Error Type:

> > Microsoft JET Database Engine (0x80040E09)

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

> > /efreelancer/guest/addemail.asp, line 75

> >

> > I can make my pages read from the Db but not write to them.

> > How can I go about correcting this problem.

> >

> > Thanks,

> > Graham




> $subst('Email.Unsub').

> >




> $subst('Email.Unsub').

> 

> 




> -- 

> Virus scanned by edNET.

Message #6 by "Scott Reed" <scottr@m...> on Wed, 23 Jan 2002 10:09:57 -0600
You or your server admin need to set I_USER permissions to

"Read/Write" for the directory that your database resides in.



It would be best to create 1 directory in the root of your

server directory and keep all of your database(s) in there.

That way, you only have to do this once.



Scott



-----Original Message-----

From: Graham Abrey [mailto:design@t...]

Sent: Sunday, January 20, 2002 5:52 PM

To: Access ASP

Subject: [access_asp] Error : Database or object is read-only





What does the following error mean:-



Error Type:

Microsoft JET Database Engine (0x80040E09)

Cannot update. Database or object is read-only.

/efreelancer/guest/addemail.asp, line 75



I can make my pages read from the Db but not write to them.

How can I go about correcting this problem.



Thanks,

Graham









Message #7 by "Graham Abrey" <design@t...> on Tue, 29 Jan 2002 08:11:34
Thanks all I have cracked the problem. I found that the ISS had to have 

the write permission all the way down to the root Virtual Folder. It was 

not good enough to just work on the DB folder its self. I also changed 

the security features allowing all users full access. I am the only user 

so its not a problem for me. 

Thanks again all for your help



Graham



> You or your server admin need to set I_USER permissions to

> "Read/Write" for the directory that your database resides in.

> 

> It would be best to create 1 directory in the root of your

> server directory and keep all of your database(s) in there.

> That way, you only have to do this once.

> 

> Scott

> 

> -----Original Message-----

> From: Graham Abrey [mailto:design@t...]

> Sent: Sunday, January 20, 2002 5:52 PM

> To: Access ASP

> Subject: [access_asp] Error : Database or object is read-only

> 

> 

> What does the following error mean:-

> 

> Error Type:

> Microsoft JET Database Engine (0x80040E09)

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

> /efreelancer/guest/addemail.asp, line 75

> 

> I can make my pages read from the Db but not write to them.

> How can I go about correcting this problem.

> 

> Thanks,

> Graham




> 




Message #8 by btodd@a... on Thu, 31 Jan 2002 20:00:35
> 

> It would be best to create 1 directory in the root of your

> server directory...



An alternative is to create the directory next to (at the same level) as 

your web directory. That stops visitors from being able to download your 

database by simply filling in it's address in the URL box in their browser.

  Return to Index