Conversion of decimal in Oracle to Access 2000

[Villy Olsson]

Hello,

I have some tables linked in Access 2000 to an Oracle 8i database. These
tables have some decimal fields.
When I looked at the tables with Sql+ the decimal fields have a comma as the
decimal separator, but in Access 2000 these fields have no decimal. 1,2 is
shown as 12.
If I use Access 97 I get the decimal, but the decimal fields are reurned as
string.
I think that I have the latest ODBC-driver from Oracle.

Can somebody help me with a solution.?

Villy Olsson,
Denmark

[Stefano G.]

"Villy Olsson" <villy.olsson@get2net.dk> wrote:
>Hello,
>
>I have some tables linked in Access 2000 to an Oracle 8i database. These
>tables have some decimal fields.
>When I looked at the tables with Sql+ the decimal fields have a comma as
the
>decimal separator, but in Access 2000 these fields have no decimal. 1,2
is
>shown as 12.
>If I use Access 97 I get the decimal, but the decimal fields are reurned
as
>string.
>I think that I have the latest ODBC-driver from Oracle.
>
>Can somebody help me with a solution.?
>

I exactly the same problem . If you recevie the solution can you repost
me too,please? (sguardigli@tomware.it)
Thank you however

>Villy Olsson,
>Denmark
>
>

[dnagel]

In the past I have turned to using the MS ODC driver. One reason
is that Oracles is a little tighter with seciurity, and if Person A created
and MDB and query with a DB link from Oracle, then Person B was not
able to put in their username and password. They had to know the
password of Person A. While the MS ODBC Driver will allow you to
change the Username as well as the password.

Maybe the MS driver will be more intelligent about the decimal type...

Just a guess, but worth a try.

D.

"Stefano G." <sguardigli@tomware.it> wrote in message news:3ca47304@10.1.10.29...
|
| "Villy Olsson" <villy.olsson@get2net.dk> wrote:
| >Hello,
| >
| >I have some tables linked in Access 2000 to an Oracle 8i database. These
| >tables have some decimal fields.
| >When I looked at the tables with Sql+ the decimal fields have a comma as
| the
| >decimal separator, but in Access 2000 these fields have no decimal. 1,2
| is
| >shown as 12.
| >If I use Access 97 I get the decimal, but the decimal fields are reurned
| as
| >string.
| >I think that I have the latest ODBC-driver from Oracle.
| >
| >Can somebody help me with a solution.?
| >
|
| I exactly the same problem . If you recevie the solution can you repost
| me too,please? (sguardigli@tomware.it)
| Thank you however
|
| >Villy Olsson,
| >Denmark
| >
| >
|

[Villy Olsson]

I will give a try. Thanks

Villy


"dnagel" <GrandNagel@hotmail.com> skrev i en meddelelse
news:3ca49915@10.1.10.29...
> In the past I have turned to using the MS ODC driver. One reason
> is that Oracles is a little tighter with seciurity, and if Person A
created
> and MDB and query with a DB link from Oracle, then Person B was not
> able to put in their username and password. They had to know the
> password of Person A. While the MS ODBC Driver will allow you to
> change the Username as well as the password.
>
> Maybe the MS driver will be more intelligent about the decimal type...
>
> Just a guess, but worth a try.
>
> D.
>
> "Stefano G." <sguardigli@tomware.it> wrote in message
news:3ca47304@10.1.10.29...
> |
> | "Villy Olsson" <villy.olsson@get2net.dk> wrote:
> | >Hello,
> | >
> | >I have some tables linked in Access 2000 to an Oracle 8i database.
These
> | >tables have some decimal fields.
> | >When I looked at the tables with Sql+ the decimal fields have a comma
as
> | the
> | >decimal separator, but in Access 2000 these fields have no decimal. 1,2
> | is
> | >shown as 12.
> | >If I use Access 97 I get the decimal, but the decimal fields are
reurned
> | as
> | >string.
> | >I think that I have the latest ODBC-driver from Oracle.
> | >
> | >Can somebody help me with a solution.?
> | >
> |
> | I exactly the same problem . If you recevie the solution can you repost
> | me too,please? (sguardigli@tomware.it)
> | Thank you however
> |
> | >Villy Olsson,
> | >Denmark
> | >
> | >
> |
>
>

[Villy Olsson]

Hi,

I have tried it now and it works. Yhanks

Villy

"dnagel" <GrandNagel@hotmail.com> skrev i en meddelelse
news:3ca49915@10.1.10.29...
> In the past I have turned to using the MS ODC driver. One reason
> is that Oracles is a little tighter with seciurity, and if Person A
created
> and MDB and query with a DB link from Oracle, then Person B was not
> able to put in their username and password. They had to know the
> password of Person A. While the MS ODBC Driver will allow you to
> change the Username as well as the password.
>
> Maybe the MS driver will be more intelligent about the decimal type...
>
> Just a guess, but worth a try.
>
> D.
>
> "Stefano G." <sguardigli@tomware.it> wrote in message
news:3ca47304@10.1.10.29...
> |
> | "Villy Olsson" <villy.olsson@get2net.dk> wrote:
> | >Hello,
> | >
> | >I have some tables linked in Access 2000 to an Oracle 8i database.
These
> | >tables have some decimal fields.
> | >When I looked at the tables with Sql+ the decimal fields have a comma
as
> | the
> | >decimal separator, but in Access 2000 these fields have no decimal. 1,2
> | is
> | >shown as 12.
> | >If I use Access 97 I get the decimal, but the decimal fields are
reurned
> | as
> | >string.
> | >I think that I have the latest ODBC-driver from Oracle.
> | >
> | >Can somebody help me with a solution.?
> | >
> |
> | I exactly the same problem . If you recevie the solution can you repost
> | me too,please? (sguardigli@tomware.it)
> | Thank you however
> |
> | >Villy Olsson,
> | >Denmark
> | >
> | >
> |
>
>