<div>
Create the table first using currency as data type for the decimal field.<br />
The run an append query.<br />
<br />
/gustav
</div>


Create the table first using currency as data type for the decimal field.
The run an append query.

/gustav

<div>
Access chokes on Decimal field types constantly. &nbsp;The only workaround I can think of would be to reformat the field to something other than Decimal (Double?), then link tables. <br />
<br />

</div>


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.



<div>
<div class="content wysiwyg-content">
I have an Access Database that has a linked table to an ODBC data source. &nbsp;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.<br />
<br />
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.<br />
<br />
I've told the company who administer the database where the linked table comes from but they insist its correct.<br />
<br />
Can anyone suggest a workaround
</div>
</div>


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

ODBC Linked Table Problem

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.