Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2001-06-14
4
369 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

860 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