新建类模块DBhelper
Option Explicit`
Dim cnn As ADODB.Connection
Dim rs As New ADODB.Recordset
Property Get excel_driver()
If Val(Application.Version) < 12 Then 'Excel版本为2003及2003以下
excel_driver = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" & ActiveWorkbook.Path & "\DataBaseSys.accdb; Jet OLEDB:Database Password=zjy;"
Else
excel_driver = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & ActiveWorkbook.Path & "\DataBaseSys.accdb; Jet OLEDB:Database Password=zjy;"
End If
End Property
''初始化数据库
Public Function db_con() As Boolean
On Error GoTo er
Set cnn = New ADODB.Connection
cnn.Open excel_driver
Exit Function
er:
db_con = False
MsgBox "数据库连接失败:"