|
Question:
I receive the following error message
when trying to save changes I made to database:
|
Microsoft OLE
DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type
mismatch in criteria expression.
/tablename_edit.asp, line xxx
|
Answer:
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 column in
Microsoft Access with an empty string ("").
Reason: MS 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 MS Access' "Date/Time" data type
specified by the associated column.
Solution: Try 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.
|
