Decimal field precision is too small to accept the numeric you attempted to add ( error 3761) in Access

Posted on 2007-10-10
Last Modified: 2008-05-24
I am getting this decimal precision error in a linked table (to an SQL server) and in the subsequent queries that use the field responsible for that error. (I have figured out by trial and error the field that causes the error)
I talked with SQL Database Admin, and was told that the error was with the decimal precision on my end. Is there a way to change the percision of the linked table and is there any other way i can overcome this error for that requried field in my queries?
Question by:mooklander
    LVL 92

    Accepted Solution

    You can only make design changes in the data source, so if you need to change the decimal
    precision, it has to be done in the SQL Server db.

    Ask the DBA what the decimal precision is, and then set up your queries not to exceed that.
    For example, if the column is set up in SQL Server as decimal(10, 4), for example, never
    pass more than 10 significant figures, and never pass a number with more than four decimal
    places.  Use the Round() function to help with the decimal portion.

    Author Comment

    Thanks Mattew.
    the linked table has the following properties. Precision :8, scale:2, decimal places: auto. and my query gives me this error when decimal is set auto or even '0'.
    As i told you the linked table also seems to show the same error, so does that mean that there is somehow a  mismatch between the linked table and the actual SQL server table, because the admin says that the errors did not show up when using Sql server Query Analyzer?
    LVL 92

    Expert Comment

    by:Patrick Matthews

    WHat kind of query are you trying to run?

    BTW, the biggest number you can fit into a decimal(8, 2) is 999999.99; if you try to put in a number
    bigger than that it will fail.  Could that be the problem?


    LVL 46

    Expert Comment

    Hi mooklander,

    Try changing the field to Currency

    Good Luck!


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
    Viewers will learn how the fundamental information of how to create a table.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now