‘Overflow’ error (Access ’97)

Topic

New Reply

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.

Reply | Quote

Replies

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

Reply | Quote

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

Reply | Quote

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.

Reply | Quote