Results 1 to 3 of 3

Thread: error

  1. #1
    linda Guest

    Default error

    I keep getting this error and I don&#039t know exactly what could be wrong....any suggestions<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e10&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. <BR><BR>The line of code it is referring me to is as follows:<BR><BR>rsreview.Open "Select sentby,date,review From reviews Where restaurantname=&#039ChrisCorner&#039",cnreview<BR> <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: error

    The error means that no data was returned for your values.<BR>This usually denotes an error with a fieldname or in your WHERE clause. Make sure your field names have the correct Case and Names.<BR><BR>rsreview.Open "Select sentby,date,review From reviews Where restaurantname=&#039ChrisCorner&#039",cnreview &#060;-- <BR>Why this &#039,cnreview&#039?<BR>Try removing this line for a test.<BR>

  3. #3
    Join Date
    Dec 1969

    Default RE: error

    I think your problem is that one of the referenced columns either doesn&#039t exist in that table (from another one, maybe) or is misspelled.

Posting Permissions

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