database error message "read only"

Results 1 to 2 of 2

Thread: database error message "read only"

  1. #1
    Join Date
    Dec 1969

    Default database error message "read only"

    i`m trying to pass a two dimensional array into an access db using the code below but i`m getting an error saying database is read only, can you see any errors in my code that would cause this. Any help, begginner level, thanks<BR><BR>&#060;%@ Language=VBScript %&#062;<BR>&#060;% Option Explicit %&#062;<BR>&#060;!--#include file="connectionOrders.asp"--&#062;<BR>&#060;!--#include virtual=""--&#062;<BR><BR>&#060;%<BR>Dim objrs<BR>set objrs = server.CreateObject("adodb.recordset")<BR> objrs.Open "orders", objconn, adOpenKeyset, adLockOptimistic, adCmdTable<BR> Dim aCart, i<BR>aCart = Session("aCart")<BR><BR>for i = 0 to ubound(aCart, 2)<BR> <BR> if aCart(0,i) &#060;&#062; "" then <BR> <BR> objrs.AddNew<BR> objrs("Style") = aCart(0,i)<BR> objrs("Description") = aCart(1,i)<BR> objrs("Qty") = aCart(2,i)<BR> objrs("Price") = aCart(3,i)<BR> objrs.Update<BR><BR> end if <BR> next<BR><BR> <BR> set objrs = nothing<BR> <BR> objconn.Close<BR> Set objconn = nothing<BR><BR><BR><BR>%&#062;<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: database error message

    check the actual file, and not just that, but the folder containing it too.

Posting Permissions

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