'引用ADO("工程"/"引用"/Microsoft ActiveX Data Objects 2.X Library)Private Sub Command1_Click() Dim cn As New ADODB.Connection, rs As New ADODB.Recordset cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\userdata.mdb;Jet OLEDB:DataBase password=a1234;"
'引用ADO("工程"/"引用"/Microsoft ActiveX Data Objects 2.X Library)Private Sub Command1_Click()
Dim cn As New ADODB.Connection, rs As New ADODB.Recordset cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\userdata.mdb;Jet OLEDB:DataBase password=a1234;"
rs.CursorLocation = adUseClient
rs.Open "Select * From userdata", cn, adOpenDynamic, adLockOptimistic
If Not rs.EOF Then
Text1.Text = rs.Fields("uname")
Text2.Text = rs.Fields("upsw")
End If
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
End Sub