Solved

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

Posted on 2001-06-14
4
356 Views
Last Modified: 2008-02-01
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 ...?
0
Comment
Question by:her7
  • 3
4 Comments
 
LVL 7

Expert Comment

by:Nosterdamus
ID: 6191897
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
 

Author Comment

by:her7
ID: 6195502
How come I'm able to import Oracle tables from Access 97 then ?

The problem seems to be only with Access 2000.
0
 
LVL 7

Accepted Solution

by:
Nosterdamus earned 100 total points
ID: 6199447
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
 
LVL 7

Expert Comment

by:Nosterdamus
ID: 6272110
Glad I could help,

Nosterdamus
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now