Pass Through Query question

[epikhigh]

Hi,

I am using Access 2003 to do a simple pass through query but I get an error when I try to run the following query:

SELECT Dev_Change_Request.Change_Request_No_, Dev_Change_Request_History.Type
FROM Dev_Change_Request
LEFT JOIN Dev_Change_Request_History
ON Dev_Change_Request.zRequest_ID = Dev_Change_Request_History.Change_Request_ID
WHERE Dev_Change_Request.Product = 'TV'

I tried running the same query as select query which works fine. The data source is ODBC. Any help would be greatly appreciated.

-EH

 

[ByteMyzer]

What is the specific error that you are getting?

What is the Database Engine of your ODBC Datasource? Is it MySQL, Microsoft SQL, Oracle,...?

 

[epikhigh]

The error message I get from Access is:
ODBC--call failed
Driver][ISAM]ISAM error (#10004)

I'm not sure which engine it uses. Probably Microsoft SQL.

 

[Jeremiah31]

Read this thread, it helped me out yesterday when I was learning how to established a pass-through without using the ODBC.

http://www.utteraccess.com/forums/showflat.

php?Cat=&Number=172417&page=&view=&sb=5&o=&fpart=2&vc=1

SELECT Dev_Change_Request.Change_Request_No_, Dev_Change_Request_History.Type
FROM Dev_Change_Request
LEFT JOIN Dev_Change_Request_History
ON Dev_Change_Request.zRequest_ID = Dev_Change_Request_History.Change_Request_ID
WHERE Dev_Change_Request.Product = 'TV'

In you're statement elimate all "_" and replace them with "." unless the underscore is in the exact field name