Why am I getting this?

Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/addxxxxxxxxx.asp, line 24

Line 24 of my code reads
objRS.AddNew

*********************Start code********************
<%
  Option Explicit
'Database connection
  Dim strConnect
%>



<%
  Dim objRS, 11111, 222222, 333333, 444444, 555555, 666666
          11111 = Request.Form("firstrecord")
          222222 = Request.Form("secondrecord")
         333333 = Request.Form("thirdrecord")
        444444 = Request.Form("forthrecord")
          555555 = Request.Form("fifthrecord")
         666666 = Request.Form("sixthrecord")
  Set objRS = Server.CreateObject ("ADODB.Recordset")
  objRS.Open "the database", strConnect, adOpenStatic, adLockOptimistic, adCmdTable


 objRS.MoveLast



      objRS.AddNew ' This line seems to be a problem
      objRS("table1") = 11111
      objRS("table2") = 222222
      objRS("table3") = 333333
      objRS("table4") = 444444
      objRS("table5") = 555555
      objRS("table6") = 666666

' Updating the database

      objRS.Update
      objRS.Close

  If objRS.EOF Then
    Response.Write "No Record added try again."
  Else
    Response.Write "Record has been added. Your the man!"
      End If

  objRS.Close
  Set objRS = Nothing
%>

*********************END code********************

Hello,

  You check the permission on the database whether you can write/update/delete.

1) Check if the .mdb file is read only. (right click the file and choose properties, uncheck if READONLY is checked)

2) Check if write permissions on .mdb file is given for the Internet Guest account (IUSR_MACHINE).

NOTE: When using Microsoft Access databases with ADO, it is also necessary to give the Internet Guest account Write permissions on the directory containing the .mdb file. This is because Jet creates an .ldb file to handle database locking. You may also need to give read/write permission on the "Temp" folder because Jet may create temporary files in this directory.

3) Check if you are opening the connection and database with proper mode for updating.

I assume the the database, in the below statement refers to the TableName. Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection