删除数据库中的一个表时显示错误
这段程序编译是粗体的xuehsnegxinxi这些字母老是显示编译错误
怎么会事呀 我已经在数据库中建了一个xueshengxinxi的表呀
谢谢了
Option Explicit
Private Sub Command1_Click()
Dim conndb 'conndb为连接
Dim sql As String
Dim connstr As String
Set conndb = CreateObject("adodb.connection")
connstr = "driver={SQL SERVER};server=zhangdy;uid=sa;pwd=;database=master"
conndb.Open connstr
sql = "select xm from xueshengxinxi"
delete from xueshengxinxi where xm ="wangping"
End Sub
