Private Sub Command2_Click() Dim db As New ADODB.Connection Dim rs As New ADODB.Recordset db.ConnectionString = "provider=microsoft.jet.oledb.4.0;" & "data source=" & App.Path & "\dev.mdb" db.Open rs.Open "select * from tablename", db Do While Not rs.EOF text1.text=text1.text & rs.Fields(0).Value & vbcrlf rs.MoveNext Loop End Sub
Dim db As New ADODB.Connection
Dim rs As New ADODB.Recordset
db.ConnectionString = "provider=microsoft.jet.oledb.4.0;" & "data source=" & App.Path & "\dev.mdb"
db.Open
rs.Open "select * from tablename", db
Do While Not rs.EOF
text1.text=text1.text & rs.Fields(0).Value & vbcrlf
rs.MoveNext
Loop
End Sub