Access to mdb does not give the correct result

Question

I am using the mdb access file (2003) as the front end of the oracle 11g R2 as a backend. I am using an odbc connection to retrieve data from an oracle database. But sometimes mdb prints the wrong output.

For example, when I use the following query in mdb

SELECT * FROM PLAN WHERE (((PLAN.BATCH_REF)="SSU080520122")); 

and it gives the wrong result. But the same query provides the correct result in the oracle.

Any help would be appreciated.

Answer 1

PLAN is a reserved word . Using reserved words as table or column names can trigger the db engine. Although this may not be the source of your problems, it would be easy to exclude him as a contributor. See if you get the results expected with this query:

 SELECT * FROM [PLAN] AS p WHERE p.BATCH_REF="SSU080520122";