PHP and Ms Access DSNless ?

[amit]

how to connect php with Ms Access?

[Drakla]

$directory="blah blah";
$filename="someaccessfile.mdb";

$db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$directory\\$filename";	

$dbh=odbc_connect($db_connstr,"","") or die ("Couldn't CONNECT to that MDB, Carol - where's me porridge");

$res=odbc_exec($dbh, $query) or die ("Query doesn't work");