Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim cnn2 As New ADODB.Connection
cnn.CursorLocation = adUseClient
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\db2.mdb;Persist Security Info=False"
cnn2.CursorLocation = adUseClient
cnn2.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\db3.mdb;Persist Security Info=False"
rs.Open "a", cnn, , adLockBatchOptimistic
Set rs.ActiveConnection = Nothing
Set rs.ActiveConnection = cnn2
rs.UpdateBatch
rs.Close
cnn.Close
cnn2.Close详细还请看C:下Search ADo*.CHM
Dim rs As New ADODB.Recordset
Dim cnn2 As New ADODB.Connection
cnn.CursorLocation = adUseClient
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\db2.mdb;Persist Security Info=False"
cnn2.CursorLocation = adUseClient
cnn2.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\db3.mdb;Persist Security Info=False"
rs.Open "a", cnn, , adLockBatchOptimistic
Set rs.ActiveConnection = Nothing
Set rs.ActiveConnection = cnn2
rs.UpdateBatch
rs.Close
cnn.Close
cnn2.Close详细还请看C:下Search ADo*.CHM
Dim rs As ADODB.RecordsetPrivate Sub Form_Load()
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\...\db1.mdb;Persist Security Info=False"
rs.Open "sql语句", cn, adOpenStatic, adLockBatchOptimistic
End Sub
set rs=nothing
set cnn=nothing释放资源
rs.fields(0)=text1.text
rs.update
或者
cnn.execute "insert into ..."
Dim rs As ADODB.Recordset
在哪定义?
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset