Can only get read-only recordset with PWS

Results 1 to 2 of 2

Thread: Can only get read-only recordset with PWS

  1. #1
    Jim Blanchard Guest

    Default Can only get read-only recordset with PWS

    FrontPage 2000<BR>NT 4.0 SP 4<BR>Microsoft Personal Web Server<BR><BR>On the above described box, the following code gives this error when the code hits the oRS.Update line:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR>[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only. <BR><BR>Set dbConn = CreateObject("ADODB.Connection")<BR>dbConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("training.mdb")<BR>sQuery = "SELECT * FROM SignUpInfo"<BR>Set oRS = CreateObject("ADODB.Recordset")<BR>oRS.Open sQuery, dbConn, 2, 2<BR>oRS.AddNew<BR>oRS("SignUpID") = request.form("SignUpID")<BR>oRS("EmployeeID") = Session("EID")<BR>oRS("SignUpDate") = now()<BR>oRS.Update<BR>oRS.Close<BR>Set oRS = nothing<BR><BR>Yet, on another machine with FP200, PWS and Win98, it works perfectly. Is there some sort of setting or such that needs<BR>to be changed on the NT machine for this to work? Oh, directory permission are set in FP to "allow scripts to be run" and "allow files to be browsed". IE5 is used on both machines.

  2. #2
    Ed Guest

    Default RE: Can only get read-only recordset with PWS

    Make sure that the Access database is in a directory where the IUSR_machinename account has write permissions turned on.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts