Public adoCNAccess As New ADODB.Connection '定义数据库的连接存放数据和代码
Public Function OpenAccess() As String
With adoCNAccess
If .State <> adStateOpen Then
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & cProgramPath & "Trade.mdb" ';password=allway"
.ConnectionTimeout = 5
.Open
If .State = adStateOpen Then
OpenAccess = "数据库连接成功"
Else
OpenAccess = "数据库连接失败,请按帮助进行检查 !"
MsgBox "数据库连接失败,请找系统管理员进行检查 !", 16, cProgramName
End
End If
End If
End With
End Function
可以啊,用ADO 2.0以上的来连接啊,DATA控件就不行了,要装上sp5才能使用Access2000的数据库。如果是用代码的就不行怕,VB是支持的。下面有个例子。
在工程引用中引用microsoft activeX data object 2.0
Private cnDB As New ADODB.Connection
Private rs As New ADODB.recordset
Private Sub DBConnection()
cnDB.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\temp.mdb;Persist Security Info=False"
cnDB.CommandTimeout = 15
cnDB.Open
End Sub
Private Sub opentable()
Dim StrSQL As String
StrSQL = "SELECT * from Temptable"
Rs.Open StrSQL, cnDB, adOpenStatic, adLockReadOnly
end sub