Connecting to a MS Access database from PHP on Linux
I found the solution to my problem was removing the ; from the query.
How to connect to MS Access database in PHP7?
To get a seamless portable database storage which works with office products as well as server based i suggest to have a look at SQLITE. The database is inside a single file which makes it highly portable between devices. It is open source, supportetd on many OS and has working connectors foe nearly anything possible. In your case you can have for example a fast ado connector in the WAMP server and on Excel and friends a native VBA connector.
Microsoft access with PHP and PDO
Write the connection object like the following and save characters case.
$dbName = "E:\\path\\to\\db.mdb";
$db = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb)};charset=UTF-8; DBQ=$dbName; Uid=; Pwd=;");
Related Topics
Why Doesn't PHP Dom Include Slash on Self Closing Tags
Strip HTML Tags and Its Contents
Laravel Collection Converts Array to Object
Get Number of Weekdays in a Given Month
Generating a Random Code in PHP
Simple PHP Mail Function Not Working on Amazon Server Ec2
Can You Pass by Reference While Using the Ternary Operator
Compare Two Version Strings in PHP
How to Change the Sequence of 'Joins' in Cakephp
Php: How to Convert Bigint from Int to String
Mongodb Get _Id as String in Find Query
Is There a Function Similar to Settimeout() (Javascript) for PHP
Codeigniter PHP Stylesheet Link. How
PHP Eval That Evaluates HTML & PHP
Rewrite All Queries to Not Need the .PHP Extension Using a Mod_Rewrite Rewriterule