DAO Problem - ADDNEW()

Results 1 to 2 of 2

Thread: DAO Problem - ADDNEW()

  1. #1
    Randy Guest

    Default DAO Problem - ADDNEW()

    I am tring to write a new record to a simple Access 8.0 database and I keep receiving this error: <BR><BR>Any Help Would be most helpful!<BR><BR>This is the asp code:<BR><BR>&#060;%<BR>Dim Connect, rst, Query<BR>Set Connect = Server.CreateObject("ADODB.Connection")<BR>Connect .Open "Menu"<BR>Set rst = Server.CreateObject("ADODB.Recordset")<BR>Query = "Select * From tblWorkOrders ORDER By ID"<BR>rst.Open Query, Connect<BR>%&#062;<BR><BR>.....<BR><BR>&#060;%<BR> rst.addnew &#039(This is line 61)<BR><BR> rst("Department") = request("Department")<BR> <BR>rst.Update<BR><BR>rst.close<BR>rst = nothing<BR><BR>%&#062;<BR><BR><BR>This is the error that I recieve.............<BR><BR>ADODB.Recordset error &#039 800a0cb3&#039 <BR><BR>The operation requested by the application is not supported by the provider. <BR><BR>/myweb2/AIMES.asp, line 61 <BR><BR>Randy<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: DAO Problem - ADDNEW()

    you need to define the LockTypes<BR><BR>your connection was a readonly forwardonly.

Posting Permissions

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