Option ExplicitPrivate Sub Command1_Click()
Dim conn As New ADODB.Connection
Dim rs As ADODB.Recordset
Dim Cnstr$, SQL$
Dim filename$
filename = App.Path & "\MIS.mdb"
Cnstr = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & filename SQL = "select * from login"
rs.Open SQL, conn, 1, 3
End Sub
Dim conn As New ADODB.Connection
Dim rs As ADODB.Recordset
Dim Cnstr$, SQL$
Dim filename$
filename = App.Path & "\MIS.mdb"
Cnstr = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & filename SQL = "select * from login"
rs.Open SQL, conn, 1, 3
End Sub
Dim conn As New ADODB.Connection
Dim rs As ADODB.Recordset
Dim Cnstr$, SQL$
Dim filename$
filename = App.Path & "\MIS.mdb"
Cnstr = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & filename
conn.open Cnstr
SQL = "select * from login"
rs.Open SQL, conn, 1, 3
End Sub
Dim rs As new ADODB.Recordset
Dim Cnstr$, SQL$
Dim filename$
filename = App.Path & "\MIS.mdb"
Cnstr = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & filename
if conn.state=adstateopen then conn.close
conn.open cnstr SQL = "select * from login"
if rs.state=adsateopen then rs.close
rs.Open SQL, conn, 1, 3
Private Sub Command1_Click()
Dim conn As New ADODB.Connection
Dim rs As ADODB.Recordset
Dim Cnstr$, SQL$
Dim filename$
filename = App.Path & "\MIS.mdb"
Cnstr = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & filename
conn.open Cnstr
SQL = "select * from login"
rs.Open SQL, conn, 1, 3
End Sub
=====================================================================
会出错, 对象变量或 with 块变量未设置
错误指向 rs.Open SQL, conn, 1, 3
Dim conn As New ADODB.Connection
Dim rs As new ADODB.Recordset
Dim Cnstr$, SQL$
Dim filename$
filename = App.Path & "\MIS.mdb"
Cnstr = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & filename
if conn.state=adstateopen then conn.close
conn.open cnstr SQL = "select * from login"
if rs.state=adsateopen then rs.close
rs.Open SQL, conn, 1, 3
================================================================adsateopen 未定义?我第一次接触adodb,不知道怎么用