'作用: 连接Access数据库
'参数: DBName 数据库名
Public Sub ConnAccess(ByVal DBName As String)
Dim strDB As String
mCnnDB.CursorLocation = adUseClient
mCnnDB.Provider = "Microsoft.Jet.OLEDB.4.0"
mCnnDB.Open(app.path + DBName, "Admin")
End Sub
或事:
Dim CN As New ADODB.Connection '定义数据库的连接
Dim Rs As New ADODB.Recordset