Hi guys,

I'm using PHP to access a MS Access database using the following code:

$conn = new COM ("ADODB.Connection") ;

$strConn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath ("/server/path/to/database.mdb") ;

$conn->open ($strConn) ;

Before anyone makes alternative suggestions, we can't have MySQL, can't set system DSNs to use odbc functions and haven't got ADO class libraries installed that we can find! My question is: is it possible to use passwords with the above connection string? I've tried:

$strConn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath ("/server/path/to/database.mdb") ."PWD='password'" ;

But to no avail. Any thoughts on this?