|
 |
asp_discuss thread: asp error-help!!!
Message #1 by "cathy" <jmjsilk@c...> on Mon, 19 Nov 2001 16:28:17
|
|
Microsoft JET Database Engine error '80040e09'
Cannot update. Database or object is read-only.
i keep on getting this error....i need help
here's some of codes...
'create a recordset object
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open "GB", objConn, adOpenDynamic, adLockOptimistic,
adCmdTable
objRS.AddNew
objRS("name") = strName
If (len(strLocation)) > 0 then
objRS("location") = strLocation
End If
If (len(strEmailAdd)) > 0 then
objRS("email") = strEmailAdd
End If
If (len(strURL)) > 0 then
objRS("URL") = strURL
End If
If (len(strComments)) > 0 then
objRS("comments") = strComments
End If
objRS("dateentered") = now()
objRS.Update
objRS.Close
objConn.Close
Message #2 by "Scott Reed" <scottr@m...> on Mon, 19 Nov 2001 16:55:31 -0600
|
|
Make sure the database is in a directory that has write permissions. Also,
you may want to check the I_USER
permissions. I typically keep all of my databases in a directory called
"datastore" and set the appropriate
permissions for that directory.
Scott Reed
-----Original Message-----
From: cathy [mailto:jmjsilk@c...]
Sent: Monday, November 19, 2001 4:28 PM
To: asp_discuss
Subject: [asp_discuss] asp error-help!!!
Microsoft JET Database Engine error '80040e09'
Cannot update. Database or object is read-only.
i keep on getting this error....i need help
here's some of codes...
'create a recordset object
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open "GB", objConn, adOpenDynamic, adLockOptimistic,
adCmdTable
objRS.AddNew
objRS("name") = strName
If (len(strLocation)) > 0 then
objRS("location") = strLocation
End If
If (len(strEmailAdd)) > 0 then
objRS("email") = strEmailAdd
End If
If (len(strURL)) > 0 then
objRS("URL") = strURL
End If
If (len(strComments)) > 0 then
objRS("comments") = strComments
End If
objRS("dateentered") = now()
objRS.Update
objRS.Close
objConn.Close
Message #3 by "Babu" <babumk@r...> on 20 Nov 2001 03:59:29 -0000
|
|
Hi Cathy,=0D=0A=0D=0AThe problem is due to either your database file or the
database file directory is read only. Change the read-only option and chec
k it.=0D=0A=0D=0ARegards,=0D=0ABabu=0D=0A=0D=0A=0D=0A=0D=0AOn Mon, 19 Nov 2
001 cathy wrote :=0D=0A> Microsoft JET Database Engine error '80040e09' =0D
=0A> =0D=0A> Cannot update. Database or object is read-only. =0D=0A> =0D=0A
> i keep on getting this error....i need help=0D=0A> =0D=0A> =0D=0A> here's
some of codes...=0D=0A> 'create a recordset object=0D=0A> Set objRS =3D S
erver.CreateObject("ADODB.Recordset")=0D=0A> objRS.Open "GB", objConn, adO
penDynamic, =0D=0A> adLockOptimistic, =0D=0A> adCmdTable=0D=0A> =0D=0A> o
bjRS.AddNew=0D=0A> =0D=0A> objRS("name") =3D strName=0D=0A> =0D=0A> If
(len(strLocation)) > 0 then=0D=0A> objRS("location") =3D strLocation=0D
=0A> End If=0D=0A> If (len(strEmailAdd)) > 0 then=0D=0A> objRS("email")
=3D strEmailAdd=0D=0A> End If=0D=0A> If (len(strURL)) > 0 then=0D=0A>
objRS("URL") =3D strURL=0D=0A> End If=0D=0A> If (len(strComments)) > 0 th
en=0D=0A> objRS("comments") =3D strComments=0D=0A> End If=0D=0A> objRS(
"dateentered") =3D now()=0D=0A> =0D=0A> objRS.Update=0D=0A> objRS.Close
=0D=0A> objConn.Close=0D=0A> =0D=0A> ---=0D=0A> You are currently subscrib
ed to asp_discuss as: =0D=0A> babumk@r...=0D=0A> To unsubscribe s
end a blank email to =0D=0A> $subst('Email.Unsub')=0D=0A>
=0D=0A =0A
Message #4 by "Taher Moiyed" <taherm@f...> on Tue, 20 Nov 2001 10:59:19 -0000
|
|
Hi Cathy,
You need to set file permissions to write to the folder where your DB lies
on to the server.
taher
-----Original Message-----
From: cathy [mailto:jmjsilk@c...]
Sent: 19 November 2001 16:28
To: asp_discuss
Subject: [asp_discuss] asp error-help!!!
Microsoft JET Database Engine error '80040e09'
Cannot update. Database or object is read-only.
i keep on getting this error....i need help
here's some of codes...
'create a recordset object
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open "GB", objConn, adOpenDynamic, adLockOptimistic,
adCmdTable
objRS.AddNew
objRS("name") = strName
If (len(strLocation)) > 0 then
objRS("location") = strLocation
End If
If (len(strEmailAdd)) > 0 then
objRS("email") = strEmailAdd
End If
If (len(strURL)) > 0 then
objRS("URL") = strURL
End If
If (len(strComments)) > 0 then
objRS("comments") = strComments
End If
objRS("dateentered") = now()
objRS.Update
objRS.Close
objConn.Close
taherm@f...
|
|
|
View Cart
