使用ado控件怎么关闭access数据库?详细代码

来源:百度知道 编辑:UC知道 时间:2024/06/15 04:33:17
因为初学我用的是adodc控件连接access数据库
Ado.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db1.mdb;Persist Security Info=False"

我想关闭数据库的连接,但不会用代码实现

On Error Resume Next
Dim cnn As ADODB.Connection
Dim cmd As ADODB.Command
Dim rst As ADODB.Recordset
Set cnn = New ADODB.Connection
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;……"
cnn.Open
Set cmd = New ADODB.Command
Set cmd.ActiveConnection = cnn
cmd.CommandType = adCmdText
cmd.CommandText = "SELECT A.* FROM A"
Set rst = New ADODB.Recordset
rst.CursorLocation = adUseClient
rst.CursorType = adOpenDynamic
rst.LockType = adLockOptimistic
rst.Open cmd
Zone = rst.Fields(1)