Thread: ODBC, Numeric and Access

ODBC, Numeric and Access

From
"Ben Trewern"
Date:
All,

I'm using Access 97 and the 7.2.5 ODBC driver to access a Postgres 7.3
database. Some of the fields are Numeric(18,4) and when they are used by
Access they show up as Text!  Is there any way of getting them to work like
Currency or Double.  I've looked in the FAQ and it recommends a float but
that will give nasty rounding errors.

Any ideas would be appreciated.

Regards,

Ben

_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail