“[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. (37000)” – MCL Error Message
Summary
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.
Explanation
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.
Solution
Select the drop down menu for each field and select a value.
Additional Comments
Issue Found: OS: Windows 2008R2, Application: MCL v3, Database: Access
Author
Related Articles
- Frequent Data Packet Drops and Retries – MCL Problem
- “Status_repetitionblock” – MCL-Net Error
- MCL-Net Log Definitions – MCL Reference Article
- Install MCL Client on a Datalogic Falcon X3 Running CE 6 – Instructional Article
- Activate MCL Client License – MCL Instruction Article
- Access the MCL Main Menu Client on a Datalogic Falcon X3 – MCL Instructional Article