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.

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"rtiguy" <rtiguy@discussions.microsoft.com> wrote in message
news:B2359508-C7E0-40DD-B3FA-A77FDF1249DB@microsoft.com...
>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

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]" wrote:

> 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.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
>
> "rtiguy" <rtiguy@discussions.microsoft.com> wrote in message
> news:B2359508-C7E0-40DD-B3FA-A77FDF1249DB@microsoft.com...
> >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.
>
>
>

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

"rtiguy" <rtiguy@discussions.microsoft.com> wrote in message
news:7ACC47DD-4AA6-49EA-95AF-BE591DD49EFD@microsoft.com...
> 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]" wrote:
>
>> 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.
>> --
>> Arvin Meyer, MCP, MVP
>> http://www.datastrat.com
>> http://www.mvps.org/access
>> http://www.accessmvp.com
>>
>>
>> "rtiguy" <rtiguy@discussions.microsoft.com> wrote in message
>> news:B2359508-C7E0-40DD-B3FA-A77FDF1249DB@microsoft.com...
>> >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.
>>
>>
>>