Did you read the notes regarding password length, password content and
Access version issues?

Do any of these apply to you?

I suspect one of them does.

On 4 June 2014 21:48, Kjell Hansen <kj...@kejpa.com> wrote:

> Hi,
> I'm trying to connect to a MS Access database that has a database password
> set.
> According to http://www.connectionstrings.com/access/ you use the
> folowing as a connection string in such cases:
> Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
> Jet OLEDB:Database Password=MyDbPassword;
> Which I translate into
> $dbcon = new PDO( 'odbc:Driver={Microsoft Access Driver
> (*.mdb)};DBQ=C:\\exampledb.mdb;Jet OLEDB:Database Password=MyDbPassword;'
> );
> But it doesn't work :(
> When I have removed the password, there's no problem connecting but not
> with password set.
> I don't make the database, it's maintained elsewhere and I plan to
> download it regularly and extract data from it so I need to connect to the
> database with the password set.
> Any help or hints are deeply appreciated!
> /Kjell
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

Richard Quadling
Twitter : @RQuadling
EE : http://e-e.com/M_248814.html
Zend : http://bit.ly/9O8vFY

Reply via email to