Results 1 to 14 of 14

Thread: search option...error 3219 RESOLVED

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2005
    Posts
    334

    search option...error 3219 RESOLVED

    when a user performs the search on my system for the second time i get error "3219 Operation not allowed in this context".... and has an error with the following code when i trying to create the rs for the second time

    With rs
    If .State = adStateOpen Then
    .Close - has an error with this line
    End If
    .CursorLocation = adUseClient
    rs.Open str, cnnSV, adOpenDynamic, adLockOptimistic
    End With

    I dont understand why its got problem with this line, I have tried introducting rs.Close straight after I retrieve the data from the rs but it has a problem with that 2

    WOT AM I DOIN RONG????
    Last edited by pame1la; Apr 4th, 2005 at 09:04 AM.

Posting Permissions

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



Click Here to Expand Forum to Full Width