Solved

Date query paramaters sent to odbc linked table no longer works

Posted on 2013-01-15
2
786 Views
Last Modified: 2013-01-21
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
Comment
Question by:upobDaPlaya
2 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 38780823
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
 

Author Comment

by:upobDaPlaya
ID: 38781100
I checked and both boxes are blank..
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now