I have linked via odbc from within MS Access 2003 to a table in an oracle database. In oracle the field would display a whole number such as 410000000000020000000. In oracle it's defined as number and size of 21. When I view the table in access the numbers appear like this, 5.161210817784058105E+18. When you look at the table in design the field size is decimal thus it's not correctly interpereting this particular field as it's defined in oracle. How can I get the number to display correctly in MS Access as a whole number.
The oracle Database is 8.1.7.4 and the client version is 8.1.7.
