This driver provides a connection to Microsoft Access databases, via an ODBC connection. The easiest way to connect to the database is to define a DSN in the ODBC connection manager and connect via that.

None

In ADOdb V5, the field type returned in metaColumns is the metaType, not the actualType. For more on this issue, see This Thread on Github. This behaviour changed in Version 5.21, but a backward compatibility mode is provided:

$db = newAdoConnection('access');
$db->metaColumnsReturnType = METACOLUMNS_RETURNS_META;

Depending on the database security, some meta functions may not be available. For more information, try this Stack Overflow response.

$db= newAdoConnection('access');
$db->connect('northwind'); 
 
$sql = 'select * from products';
$result= $db->Execute($sql);

$db = ADONewConnection('access');  
 
$dsn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=d:\\northwind.mdb;Uid=Admin;Pwd=;";
$db->Connect($dsn);