[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

[tsgorrie]

Check the spelling of your field and table names - ie if you type SCHOL instead of SCHOOL, the query engine will think the SCHOL is a parameter

Use square brackets around any table/field names which contain spaces ie [SCHOOL ID], but you "" around values

iE WHERE [SCHOOL NAME]="D B CORP"