No, you are doing something wrong.
Show your actual ASP code.
Or, better, try that query DIRECTLY IN ACCESS, first. Without involving ASP.
If that gives you an error, hopefully it will better tell you what your error is.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.