Re: Access linked table column shows datatype text for oracle number column dimensioned as 16,0 why

I ran in to the same thing with various ODBC drivers for other databases as well. The problem is that the ODBC driver is *correctly* reporting the column type/precision to Access and Access can only handle up to 15 digits of precision in a number. So anything larger Acess treats as text. OpenLink (www.openlinksw.com) has implemented a configuration based workaround (i.e. you can turn it on or off depending on your needs) to fool Access in to thinking the precision is 15 digits for larger decimals. (At least they have done this for the Informix database agent.) There is a danger in doing this however, in that if your data actually contains numbers of more than 15 digits of precision, an error may result or even worse the results will be unpredictable.

HTH,

--
Irwin Goldstein
Objective Software Systems, Inc.
http://www.objectsoft.com

In article <8gmagc$k2e$1_at_hiram.io.com>,
  "Sean Harvell" <sean_at_harvell.com> wrote:


> Access linked table column incorrectly shows datatype as text for an

 oracle


> number column dimensioned as 16,0

> or greater ex: 17,0 or 28,0... If the column is dimensioned as 15,0

 or less


> (ex 14,0 or 5,0)

> it interprets the field as a number correctly. Could someone please

 let me


> know of a fix or

> workaround you might have found!!!!

>

> Thank You!!!

> -Sean M. Harvell

> sean_at_harvell.com

>

>



Sent via Deja.com http://www.deja.com/
Before you buy.