Oracle linked tables

[rtiguy]

I have a Access 2003 application that uses tables linked from an Oracle
database server. For tables that are linked that contain DOUBLE PRECISION
fields, those fields show up in the table under design view as a number
fields. For tables that are linked that contain NUMBER fields, those fields
show up in the table under design view as text.

Is there a reason for this?

Thanks.

 

[Arvin Meyer [MVP]]

Access reads the first 8 to 20 rows of data and decides what it thinks the
datatype is. A number datatype can be an Integer, Long Integer, Single,
Double, Decimal, or Byte, so you need to look in the area in the lower left
corner for the actual datatype.

During the import/link process you can specify datatypes, and you can save
that Import Specification.

 

[rtiguy]

Arvin

I tried re-linking the Oracle tables and did not see where I had the option
to specify datatypes during the process. If I select one of the tables and
then go to design view I can change the data types for all of the fields, but
when I go to save I get a message that the changes can't be made for linked
tables.

Any other suggestions would be appreciated.

Thanks.

 

[Arvin Meyer [MVP]]

I just checked and linking an Oracle table doesn't give you those choices.
Access should be able to read the datatype from the Oracle data though. You
may have to import the data from the link by appending the linked Oracle
table to an Access one. Then write back the changed data.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com