Re: MS Access Connection with database password

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 <kjell@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