I need to access a MS Access database with PHP.
The MSAccess file's name can change so I am trying to use DSN'less connection string shown on PHP.net.
$mdbFilename='test.mdb';
$user = '';
$password = '';
$connection = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=$mdbFilename", $user, $password);
I am getting error;
Warning: odbc_connect(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'., SQL state S1000 in SQLConnect in ...
I need some help connecting to that file.
(Extra question what to do if the file extension is not ".mdb" It's something like ".bws" )
Thanks