Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 356
  • Last Modified:

ODBC Linked Table Problem

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
Northumberland
Asked:
Northumberland
1 Solution
 
NavicertsCommented:
Linking it to FoxPro?
0
 
Gustav BrockCIOCommented:
Create the table first using currency as data type for the decimal field.
The run an append query.

/gustav
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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
 
PendragonZeroCommented:
read it from the table as a string and convert it back to decimal
use this CDbl(Cstr([RTCOST]))
pen
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.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now