Originally posted by marion
Never used it myself, but I think what you need is a Pass Trough Query.
In Query Design view, choose the menu Query / SQL-Specific / Pass Through. See Access Help for details on connection etc.
ya i am using a pass threw, the thing is it verifiies the code before it realizes its a pass threw......thus my problem
Interesting, you've got me puzzled too. Although I've never worked with Pass trough queries, I've got the following thoughts:
Could it be that your SQL statement contains any parts that are specific to Access SQL, and that are not present in SQL-92 or whatever your SQL-server is expecting? For example. I understand that VBA functions are not supported in SQL-92.
So, would things like "Cur_DB.CreateQueryDef" or "Right(strItems, Len(strItems)" be available in SQL-server as well, or are these statement unique for Access?
I can imagine that if Access discovers Access-specific SQL dialect in your statement, it assumes that this is not a pass trough query, and so it starts interpreting it?