ADODB.Recordset error ' 800a0bb9'

Results 1 to 3 of 3

Thread: ADODB.Recordset error ' 800a0bb9'

  1. #1
    Join Date
    Dec 1969
    Posts
    42

    Default ADODB.Recordset error ' 800a0bb9'

    I get this really annoying bug when trying to delete a row from access;<BR><BR>ADODB.Recordset error &#039 800a0bb9&#039 <BR><BR>The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.<BR><BR>The code looks something like:<BR><BR>Set rs = server.createobject("ADODB.recordset")<BR>rs.open butikk<BR><BR>SQL = "DELETE FROM Handleliste WHERE HandleID = &#039" & delUser & "&#039 "<BR><BR>rs.execute SQL<BR><BR>rs.close<BR>set rs = nothing<BR><BR>Any ideas are appreciated!<BR>

  2. #2
    Shawn Clabough Guest

    Default RE: ADODB.Recordset error ' 800a0bb9'

    What happens when you put either a field or * in after DELETE? i.e. "DELETE * FROM Handleliste WHERE HandleID = &#039" & delUser & "&#039 "<BR><BR>

  3. #3
    Join Date
    Dec 1969
    Posts
    42

    Default RE: ADODB.Recordset error ' 800a0bb9'

    Well, I get another error message:<BR><BR>ADODB.Connection error &#039 800a0e78&#039 <BR><BR>The operation requested by the application is not allowed if the object is closed.<BR>

Posting Permissions

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