Recordset parameters not working

Results 1 to 3 of 3

Thread: Recordset parameters not working

  1. #1
    Jeremy langworthy Guest

    Default Recordset parameters not working

    I have created a recordset called RS. I want to add a new record to the recordset. I am using a connection to an Access database called MyConn. When I try to open the recordset with this code:<BR><BR> "tblCustomer", MyConn, adOpenKeySet, adLockOptimistic %&#062;<BR> <BR>I get this error:<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>It doesn&#039;t seem to matter what combinations of opening and locking parameters I use, they all return this error. <BR><BR>What the hell is going on?<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Recordset parameters not working

    try adding adCmdTable as the last (5th) parameter and check your connection string is correct<BR><BR>j

  3. #3
    Jeremy langworthy Guest

    Default RE: Recordset parameters not working

    Sorry guys my own stupid fault. Problem was I had left out the include statement for the file. Everything works fine now.<BR><BR>Cheers

Posting Permissions

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