Microsoft KB Archive/104488

From BetaArchive Wiki

ACC1x: Query Results in "Overflow" Error Message


The information in this article applies to:

  • Microsoft Access versions 1.0, 1.1


When you run a query an "Overflow" error message is returned.


This error message can occur when you use And or Or with numbers greater than 32768. For example, the following expression in the field row of a query will cause an the error:

Expr1: 32768 and 0.

NOTE: There are other causes of the Overflow error that can be avoided by using the correct data types for variables, or by modifying the expression that causes the error. This behavior is by design, and is explained in the Help topic for the Overflow error. These errors include:

  • Dividing one number by another number such that the result is larger than the data type can hold. For example,

          Dim MyVal As Integer
          MyVal = 32767 / 0.1 

    would result in setting MyVal to 327,670, which exceeds the maximum integer size of 32,767.

  • Multiplying two numbers such that the result is larger than the data type can hold.
  • Dividing any number by zero.


This problem no longer occurs in Microsoft Access version 2.0.

Keywords : kbusage
Issue type : kbprb
Technology :

Last Reviewed: November 4, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.