Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2003
    Posts
    123

    Angry Unanswered: Numeric Overflow when select *

    I get a "Numeric Overflow" when i run a SELECT * FROM TABLE,
    I've had this problem with several queries and I'm getting very annoyed by it.

    If i open the question i design view and removes everything and then adds it again it works a few times or only one time.

    Is there some kind of setting i Access that makes this happening or what?

    -Mrrrrrrrrrrrrr....

  2. #2
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Exclamation

    it depends on how your nummeric value is defined

    these are the values you can use
    name : how much memmory : value to value


    Integer : 2 bytes : -32,768 to 32,767

    Long(long integer) : 4 bytes : -2,147,483,648 to 2,147,483,647

    Single(single-precision floating-point) : 4 bytes : -3.402823E38 to
    -1.401298E-45 for negative values;
    1.401298E-45 to 3.402823E38 for positive values

    Double (double-precision floating-point) : 8 bytes :
    -1.79769313486232E308 to -4.94065645841247E-324
    for negative values; 4.94065645841247E-324 to 1.79769313486232E308 for positive values

  3. #3
    Join Date
    Jul 2003
    Posts
    123
    It must have SOMETHING to do with numeric values but I don't see how.

    I've got a link to an Excel sheet and I want to select all from it into a new table and order it by one column. The query is a "make-table" query so it deletes the old table each time it is run.

    There are some columns that are text and some that are numbers.

    The strange thing is that if I redesign the question in the exact way that it was written before it works at least one time before crashing.

  4. #4
    Join Date
    Jul 2003
    Posts
    123
    bump

  5. #5
    Join Date
    Aug 2003
    Posts
    1

    Numeric Overflow

    Originally posted by oneleg_theone
    bump
    Did you ever get a solution to the overflow problem with queries - I'm having the exact same problem making a new table from an excel spreadsheet.

  6. #6
    Join Date
    Jul 2003
    Posts
    48

    Re: Numeric Overflow

    It sounds like access is setting the type for the field based on the data from excel and in turn an overflow is happening. This does not explain why it works sometime, instead of doing a make table query try chagning to an append query, and change all of the field types in the access table to text. If this gets around thew problem then it has something to do with the above.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •