This is an old revision of the document!

Microsoft Access

Alternative Driver

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.

Specification

Driver Name	access
Status	Active
Supported OS	Windows

Driver Specific Options

None

Connection Parameters Guidelines

Using a DSN Style Connection

Field	Description	Common Example
$host	Use for the ODBC DSN Name	northwind
$userName	Not Required
$password	Not Required
$database	Not Required

Example

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

Using a DSN less connection

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

[access, supported]