Oracle numbes data types extended in MsAccess

From: NoSpam <NoSpam_at_NoSpam.com>
Date: Thu, 21 Dec 2000 11:00:45 -0500
Message-ID: <91t1ei$doc$1@ih292.ea.unisys.com>

Hi,

I've written a MsAccess Basic module to copy a linked table from Oracle to a MsAccess table. I have this problem with the NUMBER(5) and NUMBER(10) data types. NUMBER(5) gets converted to long integer and NUMBER(10) gets converted to float. I think this is actually an ODBC problem because the same module works find with a MsSQL server. I know it shouldn't be a big problem because it affects only on the space allocation but I would like to find a solution to it. Is there anyway to find out from MsAccess that the data type of a column is really NUMBER(5) or NUMBER(10) instead of long integer or float?

TIA Received on Thu Dec 21 2000 - 10:00:45 CST