Retrieving Records from MS Access 97 using VB

See more:

VB

MS-Access

Hello

I want to store and retrieve records from Access 97 and vb6.0
to store records, I wrote a the following Code:

Dim MyConn As ADODB.connection

       Set MyConn = New ADODB.connection
       Dim MyRecSet1 As New ADODB.Recordset

       MyConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\db1.mdb"
       MyConn.Open
        MyConn.Execute ("INSERT INTO table1 VALUES('" + Text1.Text + "','" + Text2.Text + "','" + Text3.Text + "')")


   MsgBox "The record was added to database", vbInformation, "Succesfull adding"
   MyConn.Close

I have two Questions
1. How to retrive those records using parametarized Query in the same way,
and store it in text boxes.

2. Is there any other way to insert and retrieve, using
Microsoft.Jet.OLEDB.4.0;