Dim MaConn As ADODB.Connection, rstChamp As ADODB.Recordset
Dim NomTable As String
'création de la connexion
Set MaConn = New ADODB.Connection
MaConn.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source=D:\JMARC\biblio.mdb"
MaConn.Open
NomTable = "Publishers"
'création du recordset contenant la structure des champs
Set rstChamp = New ADODB.Recordset
Set rstChamp = MaConn.OpenSchema(adSchemaColumns, Array(Empty, Empty, NomTable, Empty))
Do While Not rstChamp.EOF
Me.Combo1.AddItem rstChamp!COLUMN_NAME
rstChamp.MoveNext
Loop
rstChamp.Close
MaConn.Close
Partager