p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

  Return to Index  

access thread: Access/Oracle pass-through query error

Message #1 by tedalmeida@h... on Fri, 29 Jun 2001 06:35:04
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:



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

driver? Or something else?

  Return to Index