'窗体中的代码 Option Explicit Dim rs As New ADODB.Recordset Private Sub Form_Load() Dim strSQL As String strSQL = "select * from TabName" rs.Open strSQL, cn, adOpenStatic, adLockReadOnly, adCmdText If rs.RecordCount > 0 Then MsgBox "test1" End If rs.Close Set rs = Nothing End Sub '模块 Option Explicit Public cn As New ADODB.ConnectionPublic Sub GetCn() Dim iConcstr As String iConcstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\data.mdb;Persist Security Info=False;Jet OLEDB:DataBase Password='123456789987654321'" cn.Open iConcstr End Sub ------------ www.vicmiao.com 努力就有美好时光!
Option Explicit
Dim rs As New ADODB.Recordset
Private Sub Form_Load()
Dim strSQL As String
strSQL = "select * from TabName"
rs.Open strSQL, cn, adOpenStatic, adLockReadOnly, adCmdText
If rs.RecordCount > 0 Then
MsgBox "test1"
End If
rs.Close
Set rs = Nothing
End Sub
'模块
Option Explicit
Public cn As New ADODB.ConnectionPublic Sub GetCn()
Dim iConcstr As String
iConcstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\data.mdb;Persist Security Info=False;Jet OLEDB:DataBase Password='123456789987654321'"
cn.Open iConcstr
End Sub
------------
www.vicmiao.com
努力就有美好时光!