Solved

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

Posted on 2001-06-14
4
380 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
[X]
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
  • 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

717 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