I am working on a website that I was originally developing on my own 

computer running Windows 2000. It worked wonderfully (with the help of 

Beginning ASP 3.0 from Wrox. It returned records and added, deleted, and 

updated records--all from my Access database.



But when I moved all of it over to an NT internet server, I can no longer 

edit remove or add records. Returning records is no problem though, so I'm 

making a good connection to the database.



Whenever I try to add, update, or remove records, I get a message saying:

"Microsoft JET Database Engine error '80040e09' 

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



I have my Cursor and Locking settings set to:

<% objRS.Open "tblMLS", objConn, adOpenStatic, adLockOptimistic, adCmdTable 

%>



Can anyone tell me what might be wrong?



Thanks,

CWC

that's a permissions issue.  Check the permissions set on the db.  They are

"read only" right now.



Dana Coffey

Technologist, Xceed, Inc.

112 Krog St.  Atlanta, GA  30307

tel.  xxx-xxx-xxxx  x 5013

www.xceed.com



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Everything should be as simple as it is, but not simpler.

----Albert Einstein

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~







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

From: Chris W. Cotterill 

Sent: Sunday, August 27, 2000 5:35 PM

To: ASP Databases

Subject: [asp_databases] JET Database Engine Error 80040e09





I am working on a website that I was originally developing on my own

computer running Windows 2000. It worked wonderfully (with the help of

Beginning ASP 3.0 from Wrox. It returned records and added, deleted, and

updated records--all from my Access database.



But when I moved all of it over to an NT internet server, I can no longer

edit remove or add records. Returning records is no problem though, so I'm

making a good connection to the database.



Whenever I try to add, update, or remove records, I get a message saying:

"Microsoft JET Database Engine error '80040e09'

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



I have my Cursor and Locking settings set to:

<% objRS.Open "tblMLS", objConn, adOpenStatic, adLockOptimistic, adCmdTable

%>



Can anyone tell me what might be wrong?



Thanks,

CWC

No thats not it because if all the fields are filled in it works fine.





>From: "Dana Coffey" 

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

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

>Subject: [asp_databases] RE: JET Database Engine Error 80040e09

>Date: Mon, 28 Aug 2000 07:01:01 -0700

>

>that's a permissions issue.  Check the permissions set on the db.  They are

>"read only" right now.

>

>Dana Coffey

>Technologist, Xceed, Inc.

>112 Krog St.  Atlanta, GA  30307

>tel.  xxx-xxx-xxxx  x 5013

>www.xceed.com

>

>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

>Everything should be as simple as it is, but not simpler.

>----Albert Einstein

>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

>

>

>

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

>From: Chris W. Cotterill

>Sent: Sunday, August 27, 2000 5:35 PM

>To: ASP Databases

>Subject: [asp_databases] JET Database Engine Error 80040e09

>

>

>I am working on a website that I was originally developing on my own

>computer running Windows 2000. It worked wonderfully (with the help of

>Beginning ASP 3.0 from Wrox. It returned records and added, deleted, and

>updated records--all from my Access database.

>

>But when I moved all of it over to an NT internet server, I can no longer

>edit remove or add records. Returning records is no problem though, so I'm

>making a good connection to the database.

>

>Whenever I try to add, update, or remove records, I get a message saying:

>"Microsoft JET Database Engine error '80040e09'

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

>

>I have my Cursor and Locking settings set to:

><% objRS.Open "tblMLS", objConn, adOpenStatic, adLockOptimistic, adCmdTable

>%>

>

>Can anyone tell me what might be wrong?

>

>Thanks,

>CWC

>

>