Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 851
  • Last Modified:

Date query paramaters sent to odbc linked table no longer works

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..
0
upobDaPlaya
Asked:
upobDaPlaya
1 Solution
 
mbizupCommented:
Check under

Access Options -->  Object Designer --> Query Design

Ensure that you do NOT have a SQL Server Compatible option selected.

SQL Server Compatible Option
0
 
upobDaPlayaAuthor Commented:
I checked and both boxes are blank..
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now