'Overflow' message when query executes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table in an Access 2002 database, which has about 60000 records, and I'm trying to send that data into an Oracle 8.1.7 database. I have created a link to my Oracle table in Access and wrote an insert statement to insert the data from the Access table into the table in Oracle

When the query finishes executing, I get a Microsoft Access pop-up display that says 'Overflow'. It doesn't say anything else but 'Overflow'. When I check my Oracle table, the data is not in there

What does the 'Overflow' message in Access mean and how do I fix it? I've imported the data from other tables in Access to Oracle with the same number of records, keys, constraints, etc. and those were successful

I don't know what the problem is or what Access means by 'Overflow'

Please help!!!!
 
Dar,

One of the things that come to mind is if you are trying
to insert a long number into an integer field. The query
should fail to due to a type match error before then, but
who knows. You may which to check field types.

Also, how about NULL's and the constraints on the Oracle
table?

Mark
-----Original Message-----
I have a table in an Access 2002 database, which has
Click to expand...
about 60000 records, and I'm trying to send that data
into an Oracle 8.1.7 database. I have created a link to
my Oracle table in Access and wrote an insert statement
to insert the data from the Access table into the table
in Oracle.
When the query finishes executing, I get a Microsoft
Click to expand...
Access pop-up display that says 'Overflow'. It doesn't
say anything else but 'Overflow'. When I check my Oracle
table, the data is not in there.
What does the 'Overflow' message in Access mean and how
Click to expand...
do I fix it? I've imported the data from other tables in
Access to Oracle with the same number of records, keys,
constraints, etc. and those were successful.
 
The max primary key value in the Access table is 59612. Other than that, there are no other constraints in my Oracle table that I'm trying to send this data into. There are no NOT NULL, UNIQUE, or other constraints in my Oracle table execept a foreign key constraint. The max foreign key value in the Access table is 62013. From what I understand, if you define a column in Oracle as an int data type, it should hold up to over 2 million numbers. Therefore, the PK and FK values from the Access table that I'm trying to insert into my Oracle table should not cause any kind of numeric overflow.
 
Back
Top