when i perform "select distinct" statement to a table, it doesn't work, I don't know whether it's because of ODBC driver . If yes, is there any solutions ?
You'll have to give us a bit more than: "it doesn't work". Do you get any error messages?
It is not problem with your ODBC Driver. Oracle supports “Select Disctinct “ and MS Access Supports “Select Distinctrow “ Statement. It is used to retrieve unique values avoiding the duplicate entry for a particular field
