Lundi 25 Août 2025

126 codes sources

48 articles

77 news

24 Liens

15 avis

9 réponses.

Lister les tables d'une base ACCESS

Code WinDev

SQLConnecte(" \My Documents\Essai.cdb", "" , "", "", "ACCESS" , "Microsoft.Jet.OLEDB.3.51")
ListeAjoute(LISTE_TABLE, SQLListeSource())

Code C++

Code VB

Dim wConnection as ADOCE.Connection
Set wConnection = CreateObject("ADOCE.Connection.3.0")
Call wConnection.Open("\My Documents\Essai.cdb")
Dim wRecordset as ADOCE.Recordset
Set wRecordset = CreateObject("ADOCE.Recordset.3.0")
call wRecordset.Open("MSysTables", wConnection, adLockOptimistic)
Dim NombreEnregs As Long
Dim i as Long
NombreEnregs = wRecordset.RecordCount
For i = 1 to NombreEnregs
Call List1.AddItem(wRecordset.Fields("TableName").Value)
Call wRecordset.MoveNext
Next

Code Java

String strNomDriverJDBC ="sun.jdbc.odbc.JdbcOdbcDriver";

try{
Class.forName(strNomDriverJDBC);
}catch(ClassNotFoundException exception)
{

exception.printStackTrace();
}
try{

String strURL ="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=My Documents\\Essai.cdb";

Connection connection = DriverManager.getConnection(strURL,"","");
}catch(SQLException exception)
{

exception.printStackTrace();
}

	®2006 - codel5g.com