thanks..it finally works..it was my prof fault that she didnt tell me that
she has to update the permissions to write the database...it finally works
however..thank you
At 04:55 PM 11/19/2001 -0600, you wrote:
>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
>
>
>