This Error Message Article explains the Windows error message “MCL-CODE Simulator DATALOGIC Falcon X3 – [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. (37000)” and details how to fix the underlying problem that caused it to appear.
This is a failure write a new record into an Access database using an ODBC connection. In this case, we saw it using the MCL simulator with the customer’s application during testing. In the simulator, if a drop down menu is not selected, it does not enter data into the record. When the software tries to enter a blank for the field, it triggers the error.
Select the drop down menu for each field and select a value.
Issue Found: OS: Windows 2008R2, Application: MCL v3, Database: Access