v5:database:access
This is an old revision of the document!
Microsoft Access
Specification
Driver Name | access |
---|---|
Data Provider | odbc |
Status | Active1) |
Windows | Yes |
Unix | No |
ADOdb V5 | Yes |
ADOdb V6 | Yes |
Alternatives
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.
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);
Issues Accessing The Data Dictionary
Depending on the database security, some meta functions may not be available. For more information, try this Stack Overflow response.
1)
This driver is actively supported by ADOdb project members
v5/database/access.1451947154.txt.gz · Last modified: 2017/04/21 11:26 (external edit)