Oracle linked tables


R

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.
 
Ad

Advertisements

A

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.
 
R

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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top