Question

显示 语法错误（操作符丢失）在查询表达式“from 学生信息表”中

Private Sub Command1_Click()
Dim s1 As String
Dim s_id As String
Dim s_nam As String
sql = "Provider=Microsoft.jet.oledb.4.0;Data source=" & App.Path & "\驾驶员理论考试.mdb"
conn.Open sql
If Text1.Text = "" Then
s_id = "%"
Else
s_id = Text1.Text
End If
If Text2.Text = "" Then
s_nam = "%"
Else
s_nam = Text2.Text
End If
s1 = "select * from 考生信息表 where 姓名= '" & s_id & "'"
Adodc1.RecordSource = s1
Adodc1.Refresh
End Sub

Answer 1

把表名用单引号括起来试试。

Answer 2

你这个s_id成了%时,就会出现这个错误,成了where 姓名=%,这是什么条件