I'm writing a pass-through query using Access to retrieve a column from an
Oracle table. The column is a non-indexed double with a max length of 22
The problem is when the query returns a value over 32,768 Access gives me
an error message stating that "the value is out of range (#0)". I'm using
Win2000, but we get the same error on NT 4.0 & Win98. It also happens with
both Access 97 & 2000.
The SQL statement is:
SELECT UNIT_MAIN.UNIT_ID, UNIT_MAIN.IN_SERV_METER
Is there a property setting that I should be changing, or maybe the ODBC
driver? Or something else?