ado probleme

[milen]

Hii, Guys
I have my Fournisseur.mdb i want to open it manualy i but this code in my form load but he dosn't work i need your help please this is my code :

Private Sub Form_Load()

Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\WINDOWS\system32\Fournisseur.mdb;Persist Security Info=False"Adodc1.CommandType = adCmdTable

End Sub

Now Plaese i want to add the third code that allow me to chose my inscreption table i need code to open my table if you have answer
thx milen
regard's

[RhinoBull]

You had it mostly so all you needed was to assign RecordSource property to whatever table name that is:

Private Sub Command3_Click()
    With Adodc1
        .ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
                          & App.Path & "\BIBLIO.MDB;Persist Security Info=False"
        .CommandType = adCmdTable
        .RecordSource = "Authors" '<- assign your table name here
    End With
    Set DataGrid1.DataSource = Adodc1 '<- this line is not necessary - I did it only to test
End Sub