ODBC/MS Access query discrepancies

Hello all....

We have an application within Microsoft Access that queries our Oracle7 RS6000 server. We have another application that utilizes SQL*Net/ODBC and we wish to run the same queries with it. So, I have been taking some of the queries and copying then to run within the ODBC test program. As long as the sql syntax and the queries are simplistic, I have no problems. However, when I start doing more complex queries, such as those with joins, the syntax bombs with the ODBC test program (however the same query works fine within Access). It looks to me (whether correct or not) that Access is somehow changing the query sql code to something other than it shows me in order to get the query accepted by the database server. Can someone tell me if this is indeed what is happening and point me to some decent documentation on this? Or tell me that this is a stupid question and point me in the right direction? (Unix admin blindly stumbling into Microsoft territory... :-) )

Here's the version info:

On Win95:
Microsoft Access 2.0
Oracle7 ODBC Driver for Oracle7 1.11.0.5,1.11.1.5 SQL*Net 2.2.2.0.3A

Thanks for the help!

Kathy Kost
kkost_at_intermec.com Received on Tue Jul 15 1997 - 00:00:00 CDT