Hi<BR><BR>I&#039;m getting the following error come up:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80040e10&#039; <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. <BR> <BR>This is when I&#039;m trying to execute the following query<BR><BR>SELECT * FROM TblProducts WHERE varProdTyp =stools <BR><BR>stools is a variable determined by the querystring.<BR>The error relates to column names as far as i can see - the code works when choosing a different column name! but this column name exists within the Access database...<BR><BR>any clues?