Value Errors

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 is out of range for the target column’s datatype.

Note: 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 transfers.