Numeric Value out of Range
Hi,
32766 is the maximum value a small integer can hold. Make it Long in Access
or int in SQL Server and it can hold a number in the billions. If you are
reading into a VBA variable, make the variable type Long.
--
Visit www.mvps.org/project/ for the Project MVP's FAQ and third party
add-ons
Rod Gill
Microsoft Project MVP
Visit www.projectlearning.com for customized Project and Office VBA macros
and Project companion software
Quote:
> I am attempting to bring back a recordset from an Oracle database via an
ODBC call.
> The desired value is an integer 50,000.
> I get a "Numeric Value out of Range" message when the returned number
exceeds 32766
> Is this a limitation on a recordset? Can I increase this maximum value?
> Thanks in advance,
> Mike
