Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 31-08-2009
Member
 
Join Date: Aug 2009
Posts: 51
Database Error: Too few parameters. Expected 5

I am getting the below error message when I fire a query to the database. Here is the error:

Quote:
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 5.
Number: 0x80040E10
Source: Microsoft OLE DB Provider for ODBC Drivers
I am trying to figure this out but not getting why this error appears. Do you know why this error message is coming?
Reply With Quote
  #2  
Old 31-08-2009
Member
 
Join Date: Nov 2005
Posts: 1,323
Re: Database Error: Too few parameters. Expected 5

The "too few parameters" error appears when number of data fields are less as compared to the fields that is expected in the database or in the result. Make sure the number of parameters is present and at proper places. This is very common problem with wrong names or misspelled words.
Reply With Quote
  #3  
Old 31-08-2009
Member
 
Join Date: Nov 2008
Posts: 1,054
Re: Database Error: Too few parameters. Expected 5

You receive the above error message if you do not set the values of all the parameters in the parameter query. You have to explicitly assign the parameter in DAO; you do not have to explicitly assign the parameter with the DoCmd.OpenQuery. This is probably a good reason why you are getting that result. Another reason could be misspelled column name. When Jet encounters an unrecognized column name, it assumes it as a parameter.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags:



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Database Error: Too few parameters. Expected 5"
Thread Thread Starter Forum Replies Last Post
<identifier> expected error mbueling Software Development 2 18-10-2011 06:04 AM
Dynamic and static parameters in database spuff Software Development 4 22-02-2010 08:29 PM
Error '80040e10' Too few parameters Hajra Software Development 3 28-08-2009 06:05 PM
Identifier Expected Error in JAVA Brake Fail Software Development 7 25-10-2008 02:35 PM


All times are GMT +5.5. The time now is 04:46 AM.