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 

characters.



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

FROM UNIT_MAIN



Is there a property setting that I should be changing, or maybe the ODBC 

driver? Or something else?