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

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

Connection Example

DSN-less ODBC

ODBC DSNs can be created in the ODBC control panel, or you can use a DSN-less connection.

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

[access]