Value errors occur during transfer processing when the value being inserted is out of range for the column’s datatype. The access service handles these errors using the following 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, these properties can be used to fill in default values when datatype conversion fails during both types of transfer.
