Dim Conn As ADODB.Connection
Dim Rs As ADODB.Recordset
Set Conn = New ADODB.Connection
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\test.mdb;Persist Security Info=False"
sql = "select * from mytad order by id desc"
Rs.Open sql, Conn, 1, 1谢谢
Dim Rs As ADODB.Recordset
Set Conn = New ADODB.Connection
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\test.mdb;Persist Security Info=False"
sql = "select * from mytad order by id desc"
Rs.Open sql, Conn, 1, 1谢谢
这个只是定义
还要实例化
这样:
Dim Rs As New ADODB.Recordset
set rs=new ADODB.Recordset