We help IT Professionals succeed at work.
Get Started

Access 2007 "the decimal field's precision is too small"

10,434 Views
Last Modified: 2012-10-11
We are running a Make Table query that pulls from two Oracle tables.
It has always run without error every month, but this month no luck.

We receive this error in a pop-up window:
=========
Microsoft Visual Basic

Run-time error '3761':

The decimal field's precision is too small to accept the numeric you attempted to add.

[Continue]   [End]   [Debug]   [Help]
=========

That's the error we receive when it is running via the VBA that we usually run to execute everything in order.

The following, simpler error comes up if running manually, just the single query:
=========
Microsoft Office Access

The decimal field's precision is too small to accept the numeric you attempted to add.

[OK]   [Help]
=========

Any thoughts?
Thanks!
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 3 Answers and 15 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE