MS Access Connection with database password
| From: | Kjell Hansen | Date: | Wed, 04 Jun 2014 20:48:14 +0000 |
| Subject: | MS Access Connection with database password | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-48848@lists.php.net to get a copy of this message | ||
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