[AccessD] Decimal

Thanks, Drew.  It all makes perfect sense now.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Wednesday, May 14, 2008 8:48 PM
To: Access Developers discussion and problem solving
Subject: Re: [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