Hi. I'm trying to run the addnew.asp example in Chapter 14 of Beginning

ASP. Everything seems to be correct (I downloaded the example from WROX as

a check, but when I try to run the example I keep getting this same error

message:



Error Type:

Microsoft JET Database Engine (0x80040E09)

Cannot update. Database or object is read-only.

/begasp/addnew.asp, line 21



Line 21 is: objRS.AddNew



The database was opened with this line:

objRS.Open "Movies", strConnect, adOpenStatic, adLockOptimistic,

adCmdTable



I have moved the database in a directory with write permissions set. I am

able to read from the database with no problems. I don't know what the

problem is, but it's got me at a standstill. If anyone can help I'd surely

appreciate it.



Thanks,

JP

have you tried right-clicking on the actual database file and making sure it

is on "archive" and not "read-only?"



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

> From:	John Powell [SMTP:qu4gmire@h...]

> Sent:	Monday, September 25, 2000 10:08 PM

> To:	ASP Databases

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

> 

> Hi. I'm trying to run the addnew.asp example in Chapter 14 of Beginning

> ASP. Everything seems to be correct (I downloaded the example from WROX as

> a check, but when I try to run the example I keep getting this same error

> message:

> 

> Error Type:

> Microsoft JET Database Engine (0x80040E09)

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

> /begasp/addnew.asp, line 21

> 

> Line 21 is: objRS.AddNew

> 

> The database was opened with this line:

> objRS.Open "Movies", strConnect, adOpenStatic, adLockOptimistic,

> adCmdTable

> 

> I have moved the database in a directory with write permissions set. I am

> able to read from the database with no problems. I don't know what the

> problem is, but it's got me at a standstill. If anyone can help I'd surely

> appreciate it.

> 

> Thanks,

> JP

> 

> ---

> To place your message here, or to sponsor this list, please e-mail

> mailto:p2pinfo@w...?subject=MediaPack, remembering to provide contact

> details for yourself. We will e-mail you a Media Pack within 24 hours.

> 

> You are currently subscribed to asp_databases 


> $subst('Email.Unsub')

> ---

Yeah, I had checked that, & it was set correctly.



I did find the problem late last night though.



1. Right-click on the database file itself.

2. Select the "Security" tab.

3. Give write permission to everyone.



Fixed.



I'll remember this one for a long time. Sigh... :)



Thanks,

John Powell







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

From: "Foust, Joshua R." <jfoust@N...>

To: "ASP Databases" <asp_databases@p...>

Sent: Tuesday, September 26, 2000 7:56 AM

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





> have you tried right-clicking on the actual database file and making sure

it

> is on "archive" and not "read-only?"

>

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

> > From: John Powell [SMTP:qu4gmire@h...]

> > Sent: Monday, September 25, 2000 10:08 PM

> > To: ASP Databases

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

> >

> > Hi. I'm trying to run the addnew.asp example in Chapter 14 of Beginning

> > ASP. Everything seems to be correct (I downloaded the example from WROX

as

> > a check, but when I try to run the example I keep getting this same

error

> > message:

> >

> > Error Type:

> > Microsoft JET Database Engine (0x80040E09)

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

> > /begasp/addnew.asp, line 21

> >

> > Line 21 is: objRS.AddNew

> >

> > The database was opened with this line:

> > objRS.Open "Movies", strConnect, adOpenStatic, adLockOptimistic,

> > adCmdTable

> >

> > I have moved the database in a directory with write permissions set. I

am

> > able to read from the database with no problems. I don't know what the

> > problem is, but it's got me at a standstill. If anyone can help I'd

surely

> > appreciate it.

> >

> > Thanks,

> > JP

> >



> ---