[Microsoft][ODBC Microsoft Access 驱动程序] 参数不足，期待是 1

Upper_lower_limits = cursor1.execute(
            "SELECT OpenDistance_Min,OpenDistance_Max,OverTravel_Min,OverTravel_Max FROM  Param WHERE MLFB = data_mode")

显示错误：

File “C:\Users\Lee\PycharmProjects\Cpk\TEST44.py”, line 21, in

Upper_lower_limits = cursor1.execute(pyodbc.Error: (‘07002’, ‘[07002] [Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 1。 (-3010) (SQLExecDirectW)’)

**原因：**参数没传递过去

在数据库中 字符串 要用单引号 字符串变量用 “-----------'"+变量名+"'-----------”

修改如下：

Upper_lower_limits = cursor1.execute(
            "SELECT OpenDistance_Min,OpenDistance_Max,OverTravel_Min,OverTravel_Max FROM  Param WHERE MLFB = '"+data_mode+"'")