[AccessD] Decimal

Actually, ran into an issue with this in 2006.  We were converting from
Office 97 to Office 2003.  Access 97 would link tables in our Oracle DB
as Double data type.  Linking those tables in Access 2003 would link
them as Decimal.  PROBLEM, if you had queries doing calculations on
these, and the decimals were different, you would get error messages
about the expressions being too complex, or about rounding issues.  To
fix it, I linked the tables in a 97 version .mdb, then UPGRADED the
database to 2003.  This kept the link definitions the same, without
changing them to Decimal type.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
Sent: Wednesday, May 14, 2008 8:33 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Decimal

I'm not clear on just where these Decimals are being changed.  I didn't
get the impression it was in tables.  And I don't know what an Access
2003 conversion has to do with it.

Confused ...

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Wednesday, May 14, 2008 1:46 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Decimal

Hi Charlotte

I don't think you can put a general rule for the best replacement for
Decimal. Quite often Currency would be the first alternative choice.
Double - and indeed Single - may introduce new issues in an existing
app.

That said, Decimal should be avoided as data type in tables as it is
known to be buggy. In VBA, however, it can be quite useful.

/gustav

The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.