Kbase P71491: Using Access Database with ODBC dataserver getting error 1443
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
ODBC DataServer
SYMPTOM(s):
Using Access Database with ODBC dataserver getting error 1443
Duplicate unique key in database table. (1443)
MS Access ODBC driver
Field defined as number single
CAUSE:
The reason that the duplicate unique key error message was being displayed is because the values that were being assigned to the unique field were as follows:
1000.001
1000.002
When the actual assign was completed in Access the values were truncated to 1000 which cause the unique key to have two fields with the same value. By changing the definition of the field to be number double, the decimals could be assigned and therefore eliminated the duplicate numbers.
FIX:
Redefine field as follows:
change number single to number double
Format option to be generic number
If no duplicates are wanted, select that option when defining in Access.