java.sql.SQLException: [Micorsoft][ODBC Microsoft Access Driver] Too few parameters.

[Bradley Wong]

help!
i am trying to insert a record into access and i get the exception :
java.sql.SQLException: [Micorsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
i have checked the access field names, and types, and everything looks ok (spent about 6 hours checking everything!!!) the funy thing is that the program works when i update the access fields with numbers. but as soon as i put strings, i get the message above. but again, like i said, access and the insert query look like they are set up properly to accept the parameters from the query and update the db. any ideas anyone? i even tried to use a preparedStetment to get around it, but i get an error saying type mismatch. but cannot find a type problem anywhere.
thanks!!!

[David O'Meara]

Looks like you're going to have to paste some sample code for us then...
Dave

[namita pa]

ya please send the query then we can try to solve the problem.....but anyway i'll try to mention here that you yourself please check that whether you are updating the record in the same order as the column in the tables.
------------------