Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

RE: What Is An Overflow

Discussion in 'Information Technology' started by AFSSkier, Jul 28, 2006.

  1. AFSSkier

    Expand Collapse

    I get the same “Numeric field overflow†(Error 3349). The help says “The
    data in a Btrieve field is too large to represent in your applicationâ€.

    When I receive the error, I have been able to delete all of the extra unused
    field columns & then the query will run, until the next time it happens.
    However, I have a macro that runs the query as well as others.

    I can save & close it w/out any extra fields & reopen it in Design View & it
    will have 4 – 8 extra columns back in it. Is there an option preference that
    can be set to only have 1 extra field column?

    Thanks, Kevin

    "'69 Camaro" wrote:

    > Hi.
    > > What is an overflow

    > For a computer, it means that a computer command was given to store a value
    > higher or lower than the data type is capable of holding. The memory
    > location is only storing part of the actual number that it is attempting to
    > store, much like pouring too much water into a bucket. The bucket will
    > overflow, so the capacity of the bucket cannot be used to measure the actual
    > amount of water poured into it. The CPU is designed to notice this error and
    > alert the computer program so that it doesn't use the invalid data. Whenever
    > Access encounters this run-time error, the "Overflow" error message will be
    > displayed on the computer monitor so that the user is alerted to what type of
    > error Access is choking on.
    > > how
    > > do I take care of this?

    > You'll need to do some investigating to determine the cause. The most
    > common cause is attempting to store a string (or text) data type in a
    > numerical variable. Another cause is to attempt to store a very large number
    > in a data type designed for small numbers. You may find some clues as to
    > where to look by answering the following questions:
    > Is your report running a query or series of queries that make calculations,
    > then store this new data in a table? For example, trying to store a value
    > higher than 32,767 or lower than -32,768 in an integer data type field will
    > cause this error. Make sure that the field data types are big enough to hold
    > the intended data.
    > Is the report running a query that inserts records into a table from a text
    > file? Sometimes the records can't be parsed correctly and a string value is
    > inadvertently assigned to be stored in a numerical field, which can't hold
    > it, during an import.
    > Once you find the cause, you'll need to take steps to avoid the overflow
    > error, but those steps will depend entirely upon what causes the error.
    > Good luck.
    > HTH.
    > Gunny
    > See http://www.QBuilt.com for all your database needs.
    > See http://www.Access.QBuilt.com for Microsoft Access tips.
    > (Please remove ZERO_SPAM from my reply E-mail address, so that a message
    > will be forwarded to me.)
    > Beware to those who use munged addresses: known newsgroup E-mail harvesters
    > for spammers are Ripley@CASInternet.Net and scott@ripleysoftware.com
    > - - -
    > When you see correct answers to your question posted in Microsoft's Online
    > Community, please sign in to the Community and mark these posts as "Answers,"
    > so that all may benefit by filtering on "Answered questions" and quickly
    > finding the right answers to similar questions. Remember that questions
    > answered the quickest are often from those who have a history of rewarding
    > the contributors who have taken the time to answer questions correctly.
    > "JOM" wrote:
    > > I am trying to run my reports and am receiving an error saying overflow, how
    > > do I take care of this?
  2. Loading...

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page