Dim a As New AdodB.Connection
Dim c As New AdodB.RecordsetDim b As StringPrivate Sub Form_Load()a.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=43.mdb;Persist Security Info=False"
Set c = New AdodB.Recordset
b = "select name from text "
c.Open b, a, adOpenDynamic, adLockOptimistic, adCmdTextText1.Text = c.Fields("Name")
End Sub
我在做一个ado连接ACCESS 表text字段name的东西
并想把name字段的数据显示在textbox上我的程序是上面那样写但是他老报错,说“from 字句语法错误 ”谢谢你们帮我看看。到底错在哪
Dim c As New AdodB.RecordsetDim b As StringPrivate Sub Form_Load()a.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=43.mdb;Persist Security Info=False"
Set c = New AdodB.Recordset
b = "select name from text "
c.Open b, a, adOpenDynamic, adLockOptimistic, adCmdTextText1.Text = c.Fields("Name")
End Sub
我在做一个ado连接ACCESS 表text字段name的东西
并想把name字段的数据显示在textbox上我的程序是上面那样写但是他老报错,说“from 字句语法错误 ”谢谢你们帮我看看。到底错在哪
最好不要起 name,key , system 这样的字段!