Error '80040e07' - Data type mismatch in criteria expression
Issue
The SQL error 80040E07 occurs when attempting to use the Insert Record or the Update Record server behavior to set the value of a Date/Time column in Microsoft Access with an empty string ("").
Reason
Access is characterized by strong data typing; it imposes a rigorous set of rules on given column values. The empty string value in the command text (SQL) cannot be stored in a field in Access that is specified to be a Date/Time data type.
Solution
This is a known issue and Macromedia's Engineers are aware of it. Currently, the only known work around available is to avoid inserting and/or updating columns of "Date/Time" data types in Access with empty strings, ("") or with any other value that does not correspond to the range of values specified for the data type.
This content requires Flash
To view this content, JavaScript must be enabled, and you need the latest version of the Adobe Flash Player.
Download the free Flash Player now!
