Hi again,
It's an Access 2000 database and I've changed the password to a single a,
still no show :(
The database is downloaded on a regular basis and I need to extract some
data from it, so I have no control over version or password.
Thanks a lot
/Kjell
"Richard Quadling" skrev i meddelandet
news:CAKUjMCWXJfFvC_0vKq7Y4_QX-4mLumE=TOU4_v+s=YjSPZQ1VA@xxxxxxxxxxxxxx...
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@xxxxxxxxx> 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
