|
|
![]() |
| Thread Tools | Search this Thread |
#1
| |||
| |||
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:
|
#2
| |||
| |||
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. |
#3
| |||
| |||
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. |
![]() |
|
Tags: database error |
Thread Tools | Search this Thread |
|
![]() | ||||
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 |