Private Sub Form_Load()
Dim cn as ADODB.Connectinon
Dim Rs AS ADODB.Recordset
Dim strSQL as string
Set cn=New ADODB.Connection
Set Rs=New ADODB.Recordset
cn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "Nwind.mdb;Persist Security Info=False"
cn.Open '打開連接
strSQL="select * from table "
Rs.open setSQL,cn ’將數(shù)據(jù)庫操作放入Recordset
cn.Execute strSQL '執(zhí)行操作
內(nèi)容:
Cn.close
set cn= nothing
oRs.close
set oRs=Nothing
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
end sub