Oracle Field Not Displayed Correctly In MS ACCESS

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 361,053 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,187 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Oracle advertiser:

Thread Tools Display Modes

Views: 2339 | Replies: 0

•

Join Date: Oct 2005

Posts: 1

Reputation: episudics is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

episudics

Offline

Newbie Poster

Oracle Field Not Displayed Correctly In MS ACCESS

Oct 5th, 2005

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.