Re: [PHP-DB] MS Access Connection with database password

2014-06-06 Thread Karl DeSaulniers
I think the code you translated might be for the .accdb file. In your translated code I noticed .mdb so per that page, this apples for .mdb With database password (mdb file) This is the connection string to use when you have an Access 97 - 2003 database protected with a password using the "Set D

Re: [PHP-DB] MS Access Connection with database password

2014-06-06 Thread Kjell Hansen
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 meddelan

RE: [PHP-DB] MS Access Connection with database password

2014-06-05 Thread Kjell Hansen
quot;Kjell Hansen" Cc: php-db Subject: Re: [PHP-DB] 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 wrote:

Re: [PHP-DB] MS Access Connection with database password

2014-06-05 Thread Richard Quadling
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 wrote: > Hi, > I'm trying to connect to a MS Access database that has a database password > set. > Accordi

[PHP-DB] MS Access Connection with database password

2014-06-04 Thread Kjell Hansen
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