Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    LA, CA
    Posts
    18

    Red face Unanswered: recordset.open/Jet security... PLEASE HELP!!!

    Hi I am trying to update a record on linked Access 2003 tables using ADO and for some reason I get a "no value given for one or more of the required parameters" error msg from my recordset.Open method.
    The code that I’m using is this…

    ...
    Dim rsContact As New ADODB.Recordset
    Dim SQLStmt As String

    SQLStmt = "SELECT * FROM qryUserContacts WHERE chrSocSecNum = " & Me!chrSocSecNum
    rsContact.Open SQLStmt, CurrentProject.Connection, adOpenDynamic, adLockOptimistic
    If Not rsContact.EOF Then
    rsContact!blnSentToCloser = True
    rsContact.Update
    End If
    rsContact.Close
    Set rsContact = Nothing

    Exit Sub


    Also, these dbs implement Jet security... Does this matter?

    I would really appreciate any your help… Thanks
    Last edited by matatan; 02-03-04 at 15:51.

  2. #2
    Join Date
    Nov 2002
    Location
    Wyoming
    Posts
    48

    Re: recordset.open/Jet security... PLEASE HELP!!!

    Originally posted by matatan
    Hi I am trying to update a record on linked Access 2003 tables using ADO and for some reason I get a "no value given for one or more of the required parameters" error msg from my recordset.Open method.
    The code that I’m using is this…

    ...
    Dim rsContact As New ADODB.Recordset
    Dim SQLStmt As String

    SQLStmt = "SELECT * FROM qryUserContacts WHERE chrSocSecNum = " & Me!chrSocSecNum
    rsContact.Open SQLStmt, CurrentProject.Connection, adOpenDynamic, adLockOptimistic
    If Not rsContact.EOF Then
    rsContact!blnSentToCloser = True
    rsContact.Update
    End If
    rsContact.Close
    Set rsContact = Nothing

    Exit Sub


    Also, these dbs implement Jet security... Does this matter?

    I would really appreciate any your help… Thanks
    If your Social Security Number is not in a text field, I belive your SELECT statement should read:

    SQLStmt = "SELECT * FROM qryUserContacts WHERE chrSocSecNum = '" & Me!chrSocSecNum & "'"
    Cheers,
    Ken

  3. #3
    Join Date
    Jan 2004
    Location
    LA, CA
    Posts
    18

    Re: recordset.open/Jet security... PLEASE HELP!!!

    Originally posted by KennyG
    If your Social Security Number is not in a text field, I belive your SELECT statement should read:

    SQLStmt = "SELECT * FROM qryUserContacts WHERE chrSocSecNum = '" & Me!chrSocSecNum & "'"
    Thanks KennyG
    I actually do have the SSN in a text field...
    I appreciate the help. Cheers back

  4. #4
    Join Date
    Apr 2004
    Posts
    10

    Re: recordset.open/Jet security... PLEASE HELP!!!

    Hi there,

    I have exactly the same error, its soooo frustrating, did you find out what yours was. This is mine..

    update with jet 4 and ado error

    I am trying to do a really simple update and keep getting errors whatever method I use.. (have also tried using the connection.execute to update)

    Set getEventMembers = Server.CreateObject("ADODB.Recordset")
    getEventMembers.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\datetastic\Database\date tastic_database.mdb;Persist Security Info=False"
    getEventMembers.Source = "update customers set dt_customer_name = 'sib' where dt_customer_key = 2"
    getEventMembers.CursorType = adopenkeyset
    getEventMembers.CursorLocation = 2
    getEventMembers.LockType = adLockPessimistic
    getEventMembers.Open()

    I get an ASP Script Error window come up with the yellow exclamation mark triangle saying 'No value given for one or more required parameters'

    Please someone help, am at my wits end, I tried an update using the Dreamweaver GUI and its fine and looks no different to my handwritten code.

    Thanks in advance
    Many Thanks
    Siobhan

Posting Permissions

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