Decimal problems importing Oracle 8.0.5 table in an Access 200 database.

A table in Access is defined with NUMBER 16,8 datas. When I try to import it in an Access 2000 database, the error message #3761 appears telling me that there is a problem of decimal. For that reason,the table is not imported.

 A solution for this problem ...?
her7Asked:
Who is Participating?
 
NosterdamusConnect With a Mentor Commented:
Hi her7,

I do not know the answer for that, but you might want to concider installing the Office 2000 SR-2.

You can find more info, download and installation instructions here: http://support.microsoft.com/support/ServicePacks/Office/2000/SP2.asp?LN=EN-US&SD=gn&FR=0&qry=sr-2&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=OFW2K

There are many bug fixs in this SR, which one of them might solve your problem...

Hope this helps,

Nosterdamus
0
 
NosterdamusCommented:
Hi her7,

In general, there is a differance between MS Access Numeric type precision (Access 2000 - 28 Max) and Oracle Numeric DataType precision (38 Max).

You have to create the table using numbers of lower precision than the Oracle default precision of 38.

If you Import data from Oracle, then read this MS article:
http://support.microsoft.com/support/kb/articles/Q251/1/36.ASP?LN=EN-US&SD=gn&FR=0&qry=Oracle&rnk=11&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

If you Export data to Oracle DB then read this MS article:
http://support.microsoft.com/support/kb/articles/q272/3/46.ASP?LN=EN-US&SD=gn&FR=0&qry=Oracle&rnk=4&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

Hope this helps,

Nosterdamus
0
 
her7Author Commented:
How come I'm able to import Oracle tables from Access 97 then ?

The problem seems to be only with Access 2000.
0
 
NosterdamusCommented:
Glad I could help,

Nosterdamus
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.