data type mismatch means that the compiler / interpreter / sql engine has received a value of a type its not expecting
often it means that the you have supplied a numeric argument/parameter when it was expecting a string or vice versa
is not the same as
...where mycolumn = 1
it could be that you have supplied a date value when a number was expected, it coudl be the date value is not in the style that the wahtever expected.. eg you may may have supplied it in the form dd/mm/yyyy when Access normally expects mm/dd/yyyy.
...where mycolumn = "1"
it could jsut be masking a syntax error in your SQL, ie its not valid SQL and the wahtever is whinging because it cannot understand what you are trying to do
I'd rather be riding on the Tiger 800 or the Norton