Date query paramaters sent to odbc linked table no longer works
Posted on 2013-01-15
I have a ms access query that I use which has as a criteria of a date for a field called process date. As an example I put in a criteria of #01/14/2013# for the field called process date and I get an error of odbc syntax error...access violation..note the table object within the query is an odbc linked table...
Note this query works perfectly fine in ms access 2003, but fails in ms access 2010. My work around has been to use CDate('01/14/2013'), but I would like to avoid having to change a lot of queries and databases to this workaround. Any suggestions on why ##date criteria no longer work in ms access 2010 with an odbc linked table..