Is it possible to access the MS Access database using PHP on a Linux web server?

Question

Ideally, it would be great if I could upload the .mdb file to the linux web server and request it with php. Is it possible? If so, how?

Answer 1

Yes, you should have ODBC drivers for Unix installed, or the best way is probably to use PDO with php5.

* Stolen from other places on the network, not verified.

try { $dbh = new PDO("odbc:Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\accounts.mdb;Uid=Admin"); } catch (PDOException $e) { echo $e->getMessage(); } 

Answer 2

it looks like you can use mdbtools ( in the repository ), which should allow access to odbc, as well as a way to connect to another database.

Even if you cannot use it directly, porting is an option .

Answer 3

This question and answer may be of interest: PHP and Microsoft Access Database - Connection and CRUD