Private Sub Form_Load()
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim str As String
str = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=E:\标签\db1.mdb"
cnn.Open str
rs.CursorLocation = adUseClient
rs.Open "select * from table", cnn, adOpenKeyset, adLockPessimistic
cnn.Close
Set cnn = NothingEnd Sub
请问rs.Open "select * from table", cnn, adOpenKeyset, adLockPessimistic老是报错什么问题啊?
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim str As String
str = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=E:\标签\db1.mdb"
cnn.Open str
rs.CursorLocation = adUseClient
rs.Open "select * from table", cnn, adOpenKeyset, adLockPessimistic
cnn.Close
Set cnn = NothingEnd Sub
请问rs.Open "select * from table", cnn, adOpenKeyset, adLockPessimistic老是报错什么问题啊?
FROM 子句语法错误!这是什么意思啊!
rs.Open "select * from [table]", cnn, adOpenKeyset, adLockPessimistic