Connection to Access

You have to use the odbc driver. Try for the database setting string like that with your DNS name created in you windows settings:

PHP Code:

$db['default'] = array(
        ...
    'hostname' => 'Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\path\to\my.mdb', // or try only the DNS name
    'username' => 'dbusername',
    'password' => 'dbpassword',
    'database' => 'Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\path\to\my.mdb',
    'dbdriver' => 'odbc',
        ...
); 


Hope this helps.