A
Antonio Ferreira
I converted an Access97 database to Access 2003 and now I'm having
problems when I try to link or import tables from an ORACLE database!
The Links that I made to Oracle tables with the previous version (access 97)
seems to work well, the numeric fields that have decimal places, are shown
and work correctly. The problem is when try to make some new Links,
in access 2003! The fields that have decimal places are not "converted" well!
The decimal part appears as they where part of the int part,ex:
The decimal value: 2808,74 appears as an integer value: 280874.
If i add for example ,20 cents the result will be 280874,20 instead of the
2808,94!
Can you give me any help on this!?
I'm also having problems when I try to import tables (from Oracle) that have
numeric fields with decimal places!
Access 2003 gives me this message:
<b>The Decimal Field's precision is too small to accept the numeric you
attempted to add.</b>
and cancels the importation of the table!!!
Here goes an example of the Structure of one of my Oracle 8i Tables:
IDCode Not Null Varchar2(5)
DsgCode Not Null Varchar2(25)
Value Not Null Number(9,2) <- this is the field that gives me the
problems!
Any help on this subject would be Highly appreciated!!!
Thanks in advance for any help that could lead or resolve this problems...
Best Regards,
António Ferreira
problems when I try to link or import tables from an ORACLE database!
The Links that I made to Oracle tables with the previous version (access 97)
seems to work well, the numeric fields that have decimal places, are shown
and work correctly. The problem is when try to make some new Links,
in access 2003! The fields that have decimal places are not "converted" well!
The decimal part appears as they where part of the int part,ex:
The decimal value: 2808,74 appears as an integer value: 280874.
If i add for example ,20 cents the result will be 280874,20 instead of the
2808,94!
Can you give me any help on this!?
I'm also having problems when I try to import tables (from Oracle) that have
numeric fields with decimal places!
Access 2003 gives me this message:
<b>The Decimal Field's precision is too small to accept the numeric you
attempted to add.</b>
and cancels the importation of the table!!!
Here goes an example of the Structure of one of my Oracle 8i Tables:
IDCode Not Null Varchar2(5)
DsgCode Not Null Varchar2(25)
Value Not Null Number(9,2) <- this is the field that gives me the
problems!
Any help on this subject would be Highly appreciated!!!
Thanks in advance for any help that could lead or resolve this problems...
Best Regards,
António Ferreira