Member Avatar for episudics
episudics 0 Newbie Poster

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.

  • 1 Contributor
  • 0 Replies
  • 79 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.