Hello all,

In my pages I am using a recordset to add records to a table. Very 

straightforward, nothing fancy. Until recently this has been going ok. Now 

however, I am getting the following error:



Microsoft JET Database Engine error '80040e09' 



Cannot update. Database or object is read-only. 



/UploadScript.asp, line 101 



And line 101 contains: objRS.AddNew

I have recreated the .mdb file from scratch and I have put in a few lines 

to make sure that the state of the recordset that I am working with is not 

Open, but even that doesn't help. I have no idea what I did to change this 

what has been no problem for a while.

Sorry to ask such a basic question, but perhaps someone has an idea what I 

have to do to get it working again....?

thx in advance,

Henri

If you are using IIS you may need to check the security on the

database...ensure that IUSR_ has Modify rights to the database.

You may also want to check the basic "readonly " properties of the database

by right clicking on the database and selecting properties.. look on the

bottom for "read only" and uncheck it if it is checked.

Jim

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

From: "Henri von Franquemont" <hvonfranquemont@m...>

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

Sent: Wednesday, September 05, 2001 5:07 PM

Subject: [access_asp] Database or Object Read Only problem





> Hello all,

> In my pages I am using a recordset to add records to a table. Very

> straightforward, nothing fancy. Until recently this has been going ok. Now

> however, I am getting the following error:

>

> Microsoft JET Database Engine error '80040e09'

>

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

>

> /UploadScript.asp, line 101

>

> And line 101 contains: objRS.AddNew

> I have recreated the .mdb file from scratch and I have put in a few lines

> to make sure that the state of the recordset that I am working with is not

> Open, but even that doesn't help. I have no idea what I did to change this

> what has been no problem for a while.

> Sorry to ask such a basic question, but perhaps someone has an idea what I

> have to do to get it working again....?

> thx in advance,

> Henri




>

>