“Too Few Parameters” error fix


Whenever you run a SQL statement you get a “Too Few Parameters, expected X.”


Most common cause is misspelling or missing fields in the SQL statement.


Check the SQL statement. If necessary, copy and paste to an Access query and test in the query to get it to highlight which part of the SQL is treated as a parameter.