Microsoft Access 2003 Overflow Error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SimplyClassyJack - 29 Aug 2005 21:49 GMT

At this moment, I imported some tables from ODBC Databases into Microsoft
Access, made some changes, and trying to export them back to Oracle Database.
I had about 10 tables imported and every table except one table had no
problem exporting. But when I try to export the last table, there are two
different error messages coming up from two different machine (I made a copy
of file and tried on different machine and still was unsuccessful). Those
error messages are

1) Overflow Error
2) This expression is typed incorrectly, or it is too complex to be
evaluated. For example, a numeric expression may contain too many complicated
elements. Try simplifying the expression by assigning parts of the expression
to variables. (Error 3071)

The help doesn't exactly help me. Can someone please help me?

Reply to this Message

Ken Snell [MVP] - 31 Aug 2005 02:04 GMT

What types of data are you exporting? What are the values? What is the SQL
statement of the query? Those errors can arise from a number of sources --
trying to put a number larger than Integer size into an integer, having an
incomplete "date string" as a date value, trying to divide by zero, etc.

Signature

Ken Snell
<MS ACCESS MVP>

> At this moment, I imported some tables from ODBC Databases into Microsoft
> Access, made some changes, and trying to export them back to Oracle
[quoted text clipped - 15 lines]
>
> The help doesn't exactly help me. Can someone please help me?

Reply to this Message

SimplyClassyJack - 31 Aug 2005 02:50 GMT

I actually found what was the problem. There's part of the data where I enter
the date.

"During a discussion of SQL dates, Andy Winningham pointed out:
Another thing to remember about going from Access to SQL Server
regarding data conversion is that a valid date in Access may not be valid in
SQL. For example, Access will treat the date 01/01/200 as valid. However if
you try and load this date into a SQL Server database, you will get an
overflow error."
(http://www.vb-helper.com/bug_sql_date_overflow.html)

And I had a single data that had 104 as its year.
Thanks.

> At this moment, I imported some tables from ODBC Databases into Microsoft
> Access, made some changes, and trying to export them back to Oracle Database.
[quoted text clipped - 11 lines]
>
> The help doesn't exactly help me. Can someone please help me?

Reply to this Message