Access 2000, ODBC, and the Decimal datatype

[MurphOMatic]

Anyone notice this behavior?? Furthermore, anyone think that it is odd or potentially buggy?

Access 2000's Decimal datatype essentially defines that the number of digits to the LEFT of the decimal place is equal to the Precision - Scale. So, for example, create a table with one field set to type Numeric Decimal. Set the precision to 5 and the scale to 2. Now, try to type in the number 1000. It doesn't take it! You would think that you should be able to put a maximum value of 99,999 in that field with the precision set to 5.

Anyone else confirming that this is a problem?

Thanks,

Sean Murphy
Programmer/Analyst
Electro-Scientific Industries, Inc.

 

[MurphOMatic]

Furthermore, this presents a major problem with ODBC linked or imported tables. Access 2000 now defaults the datatype for incoming precision fields to be of type Decimal, instead of type Double like Access 97 did. We've been having severe problems bringing currency and other precision fields from an external 3rd party RDBMS (PROGRESS) into Access 2000.

Sean Murphy
Programmer/Analyst
Electro-Scientific Industries, Inc.

 

[MurphOMatic]

Helllllooooo?????

 

[ErikZ]

Hi.