Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Kent, England
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    'Overflow' error (Access '97)

    I am running a query which has worked since time bagan. It is an append query taking data from 2 tables within my database and one from an ODBC link. I keep get the error message "Overflow" and I'm perplexed as to the exact nature of the problem.

    I can still pull data with the ODBC link.

    Any help would be much appreciated.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Overflow' error (Access '97)

    I suspect you are adding records with values greater then a field can contain.
    Look at your numeric data fields. ex: if a field is an integer, you can't enter a value greater than 32767
    Francois

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Overflow' error (Access '97)

    I just ran into the same overflow problem with ODBC against an sql table.
    The problem was that in the input table contains 2 records exist with wrong dates (19/06/199 for 19/06/1999)
    Date type in sql server can't take data before 01/01/1753 and give the overflow error.
    Hope this help
    Francois

  4. #4
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Kent, England
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Overflow' error (Access '97)

    There was a calculated field with the formula of Field A divided by Field B. Field B should not contain any zeros - but it did.

    Once these records were eliminated, everything was hunky dory.

    Thanks for the suggestions though.

Posting Permissions

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