Problem in Under exist in Field_Name

[manoj.mcans]

I have database in Oracle by using the odbc link , I access the table in MS-Access2003 and then made the queries with that table.

I link one table from oracle database using Odbc link.
my column name in table has underscore like Field_name.

if i make Pass-through query like:
select filed_name from tablename ; Its work fine

if i make Pass-through query like
selct fild_name from tablename where tablename.field_name ="00001"

and then it does not run

this value 00001 exist for that column.

Please suggest on this issue.

 

[neileg]

By putting quotes around the criterion "00001" you are saying this field is text. Is it really text or is it a different datatype, numeric for example?

 

[manoj.mcans]

Yah its confirm its a text datatype..
i also tried like operator , but still it is not working ...
but its work except pass-through query..