This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
The contents of fields in <number> record(s) were deleted, and 0 record(s) were lost due to key violations.
- If data was deleted, the data you pasted or imported doesn't match the field data types or the FieldSize property in the destination table.
- If records were lost either the records you pasted contain primary key values that already exist in the destination table, or they violate referential integrity rules for a relationship defined between tables.
Do you want to continue anyway?
[Oracle][ODBC][ORA] ORA-01401: Inserted value too large for column (#1401)
For example, consider the following SQL syntax:
SELECT tblExample.pkeyDataID, tblExample.dblTest
SELECT tblExample.pkeyDataID, CStr([dblTest]) AS Expr1
This problem is resolved in Microsoft Jet 4.0 Database Engine Service Pack 8 (SP8). For more information about Microsoft Jet 4.0 Database Engine SP8, click the following article number to view the article in the Microsoft Knowledge Base:
Article ID: 301915 - Last Review: Oct 30, 2008 - Revision: 1