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.
