ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:database:access

This is an old revision of the document!


Microsoft Access

See also the ADO and PDO drivers for Access

Description

This driver provides a connection to Microsoft Access databases, via an ODBC connection.

Specification

Driver Nameaccess
StatusActive
Supported OSWindows

Driver Specific Options

None

Connection Parameters Guidelines

FieldDescriptionCommon Example
$host
$userName
$password
$database

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);
v5/database/access.1437763061.txt.gz · Last modified: 2017/04/21 11:26 (external edit)