1. Home
  2. Mobile App Development
  3. MCL
  4. MCL-Error Message
  5. “[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. (37000)” – MCL Error Message

“[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

 

Updated on August 10, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support