I am using Access 2000. In my application, I have linked Oracle tables
through ODBC. My question is, sometimes when you link an Oracle table, The linked table in Access shows different data types for the fields. For example, if I have a primary key of type Number(20) in an ORacle table, the same field shows up as text field in the linked table.

Any ideas how I can fix this issue or what is the explanation for such

This isdriving me nuts when I try to create joins in my queries. It
constantly errors out saying "Mismatch data type"