Value errors occur during bulk copy transfer or destination-template transfer processing when the value being inserted either cannot be converted to the target column’s datatype or it is out of range for the target column’s datatype.
Express transfer does not support value error handling—if
an error occurs, it aborts the entire transfer.
The access service handles value errors using these properties:
CharConvertError
NumConvertError
DatetimeConvertError
DefaultDate
DefaultTime
DefaultNum
If the SendWarningMessages property is set to yes, the access service sends a message to the client application when it encounters value errors.
In addition, the preceding properties can be used to fill in default values when datatype conversion fails during bulk copy and destination-template transfer.
For more information about configuration properties, see Chapter 2, “Configuring the Access Service Library.”
For information about values that cause errors for database access service during bulk copy transfer, see Chapter 9, “Using Bulk Copy Transfer and Express Transfer.”
