急!!update语句语法错误
有以下代码:
Private Sub btnOK_Click()
Dim connectionString As String
Dim cn As New ADODB.connection
Dim rs As New ADODB.recordset
Dim sql As String
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\RMData.mdb;Persist Security Info=False"
cn.Open connectionString
cn.CursorLocation = adUseClient
sql = "update UserInfo set 用户权限='" & cmbQuanxian.Text & "'where user='" & cmbUser.Text & "'"
cn.Execute sql
MsgBox "修改成功,该用户的权限为" & cmbQuanxian.Text & "!"
cn.Close
End Sub
运行后,系统提示 实时错误'-2147217900(80040e14)':
提示错误为:UPDATE语句的语法错误
哪位好心人指点一下,不知错在何处,谢谢!!