Linking to access

From: Richard Finney <richard.finney_at_yeg.co.uk>
Date: 1997/11/28
Message-ID: <01bcfc1a$4b6aa200$98675092@ye12203>#1/1

Hi Folks,

With Respect to Oracle ODBC Drivers...

Does anyone know how I can successfully attach an Oracle table which contains fields of type numeric(10) to an Access 95 or newer MDB file ? Access seems to convert the field to a long, and then refuses to open the table as some values can be beyond the limit of a long. I need to insist that it gets converted to a double.

This is not a problem with the MS ODBC drivers, but I think the Oracle ones are faster.

Many Thanks - Richard. Received on Fri Nov 28 1997 - 00:00:00 CST