Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    311

    Unanswered: rs.open no values given for required params?

    I open a rs and do some work :

    rs.Open strSQL, CurrentProject.Connection, adOpenKeyset, adLockOptimistic, adCmdText


    .......................
    .......................

    Then close rs:

    rs.Close

    when i try to re open ( with only a change to the sql) :

    rs.Open difStrSQL, CurrentProject.Connection, adOpenKeyset, adLockOptimistic, adCmdText

    i get the error :

    no values given for required params?

    Why the erratic behavior??


    M~

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    is the new query a parameterized query? What happens when you run it outside of the code?

Posting Permissions

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