I have set the permission on my DB to "Everyone",but persist in getting 
the message telling me that my DB is read-only.  It tells me the arror is 
in line 16( of my ASP code) which is AdNew().  Any suggestions?

Thanks for your help,

Rich Terry

Make sure the permission is Everyone on the DB under your InetPub and
also the AddNew looks like this not AdNew()

  objRS.Open
"codetable",objConn,adOpenForwardOnly,adLockOptimistic,adCmdTable
  objRS.AddNew
    objRS.Fields("apptype") =3D strtype
    objRS.Fields("appkeyword") =3D strkeyword
    objRS.Fields("appshortdesc") =3D strshortdesc
    objRS.Fields("appcode") =3D strcode
    objRS.Fields("appcode2") =3D strcode2
    objRS.Fields("appcode3") =3D strcode3
  objRS.Update
  intID =3D objRS("appid")
  Response.Write "<p>Record ID " & intID & " added!!</p>"
     
  objRS.Close

-----Original Message-----
From: richterry@e... [mailto:richterry@e...]
Sent: Monday, March 18, 2002 8:52 AM
To: ASP Database Setup
Subject: [asp_database_setup] Cannot update. Database or object is
read-only.


I have set the permission on my DB to "Everyone",but persist in getting
the message telling me that my DB is read-only.  It tells me the arror
is
in line 16( of my ASP code) which is AdNew().  Any suggestions?

Thanks for your help,

Rich Terry
%%email.unsub%%

adNew() is not going to work is it?!? :-)

Next time, please post the exact error message you are receiving, and the
code you are using.
Since you've already set the NTFS permissions it seems like the problem is
that you are using a ReadOnly locktype on your cursor, but without seeing
your code we can only speculate...

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <richterry@e...>
Subject: [asp_database_setup] Cannot update. Database or object is
read-only.


: I have set the permission on my DB to "Everyone",but persist in getting
: the message telling me that my DB is read-only.  It tells me the arror is
: in line 16( of my ASP code) which is AdNew().  Any suggestions?

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