Nieuw lid |
|
Volgens mij is de code die je gaf niet de oorzaak van je foutmelding.
Citaat: 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.
Met andere woorden, je doet ergens een insert- of update query en probeert dan bijvoorbeeld een "string" in een int veld te stoppen. |