function data()as adodb.recordset
dim rs as new adodb.recordset
rs.cursorlocation=aduseclient
rs.open "select id,name sex from mytable",conn
set data=rs
end function
调用
command1_clock
dim rs as adodb,recordset
set rs=data
end sub
----------------------------------------------------------------------------
Dim conn As New ADODB.Connection, rs As New ADODB.Recordset
Private Function data() As String
rs.Open "select id,[name],sex from mytable", conn
data = rs!id & "-" & rs!name & "-" & rs.sex
rs.Close
End Function
Private Command1_Click()
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;"
MsgBox data
Set rs = Nothing
conn.Close
Set conn = Noting
End Sub