Solved

ODBC Linked Table Problem

Posted on 2004-09-03
4
350 Views
Last Modified: 2008-02-01
I have an Access Database that has a linked table to an ODBC data source.  The table has a field called RTCOST which is a Decimal field with a Precision of 9 and a Scale of 3, Decimal Places are set to Auto.

I can list the contents of the table but If I try to create a Make table query i.e take the contents of the linked table and dump it into an Access local table I get a Access error message which says : The decimal fields precision is too small to accept the numeric you attempted to add.

I've told the company who administer the database where the linked table comes from but they insist its correct.

Can anyone suggest a workaround
0
Comment
Question by:Northumberland
4 Comments
 
LVL 7

Expert Comment

by:Navicerts
ID: 11972263
Linking it to FoxPro?
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 11972399
Create the table first using currency as data type for the decimal field.
The run an append query.

/gustav
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 11975312
Access chokes on Decimal field types constantly.  The only workaround I can think of would be to reformat the field to something other than Decimal (Double?), then link tables.

0
 
LVL 2

Accepted Solution

by:
PendragonZero earned 500 total points
ID: 11975316
read it from the table as a string and convert it back to decimal
use this CDbl(Cstr([RTCOST]))
pen
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

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

679 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