Private connection As String Private maconnection As New adodb.connection Private monjeu As New adodb.Recordset connection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & chemin & liste_bases.FileName & ";" & _ "Persist Security Info=False" maconnection.Open connection Set monjeu = maconnection.OpenSchema(adSchemaTables) monjeu.MoveFirst Do While Not monjeu.EOF If monjeu!TABLE_TYPE = "TABLE" Then Liste_tables.AddItem monjeu!TABLE_NAME monjeu.MoveNext Loop