Public Function OpenAccessConn() Dim AssSql As String On Error GoTo errOpenBDConnection: AssSql = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ txtMdbPath & ";Persist Security Info=False" assConn.ConnectionString = AssSql assConn.Open Exit Function errOpenBDConnection: MsgBox ("Access Database Connection failed!" & vbCrLf & Err.Number & Err.Number & _ vbCrLf & Err.Description), vbCritical, " EnterpriseIQ System" Exit Function End Function
可以添加一个公共模块,“工程”-“添加模块” 然后在里面写Public cn As New ADODB.Connection Public rs As New ADODB.Recordset Public Sub OpenConn() Set cn = New ADODB.Connection Set rs = New ADODB.Recordset cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\???.mdb;Persist Security Info=False" cn.Open rs.ActiveConnection = cn rs.CursorLocation = adUseClient End SubPublic Sub CloseConn() rs.Close Set rs = Nothing cn.Close Set cn = Nothing End Sub要用的时候就 call OpenConn() 不用就关掉 CloseConn()
Public Function OpenAccessConn()
Dim AssSql As String
On Error GoTo errOpenBDConnection:
AssSql = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
txtMdbPath & ";Persist Security Info=False"
assConn.ConnectionString = AssSql
assConn.Open
Exit Function
errOpenBDConnection:
MsgBox ("Access Database Connection failed!" & vbCrLf & Err.Number & Err.Number & _
vbCrLf & Err.Description), vbCritical, " EnterpriseIQ System"
Exit Function
End Function
然后在里面写Public cn As New ADODB.Connection
Public rs As New ADODB.Recordset Public Sub OpenConn()
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\???.mdb;Persist Security Info=False"
cn.Open
rs.ActiveConnection = cn
rs.CursorLocation = adUseClient
End SubPublic Sub CloseConn()
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
End Sub要用的时候就 call OpenConn() 不用就关掉 CloseConn()
rs.ActiveConnection = cn
rs.CursorLocation = adUseClient
这两个是什么?
datalink = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=\SFCS\data.mdb;"……
……
End Sub