DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/)
-   Oracle (http://www.daniweb.com/forums/forum129.html)
-   -   Oracle Field Not Displayed Correctly In MS ACCESS (http://www.daniweb.com/forums/thread33409.html)

episudics Oct 5th, 2005 11:22 am
Oracle Field Not Displayed Correctly In MS ACCESS
 
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.


All times are GMT -4. The time now is 2:31 pm.

Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC