I connect to a MS access database using Database Connectivity Toolset(Version 1.0.1).But I can't select the certain data useing DB Tools Execute Query.I have set condition statement to the SQL query (for example:SELECT * FROM testdata WHERE "date=2004-3-12"),but i received all the data of database. That is to say,the condition statement doesn't work.What's wrong?
