I'm getting the following error when I try to login after records were added :
Error number -2147217913
Error description [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
URL /PM/Applications/pm_approval/release_approval_list.asp
SQL query select top 20 [fileID], [fileType], [fileTitle], [fileName], [fileModifiedDate], [fileOwner], [fileMApproval], [fileMRejectReason], [filePApproval], [filePRejectReason], [fileAApproval], [fileARejectReason], [fileEApproval], [fileERejectReason], [fileOApproval], [fileORejectReason], [fileCApproval], [fileCRejectReason] From [release_approval]
Solution 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 ("").
I read the FAQ, but the date field is not empty - On the contrary, I think that this problem started after I set the Date field deafult value to Now().
What is the problem and how to solve that?
Thanks
