PHP & MS Access 2007 on Shared Linux Hosting

Question

Basically I work for a dining services company that has a menu database that we use for each week at multiple locations stored in a Microsoft Access 2007 .accdb file. I'm trying to develop a PHP application on shared hosting so that the .accdb file can be uploaded and queried as to generate and store HTML menus for the week based on the database.

Million dollar question: how can I interact with this .accdb file form within PHP on shared hosting? I guess I just kind of assumed Zend or Pear would have a driver for me when I started off, but I'm having some trouble finding anything of substance, especially for shared hosting.

Thanks!

Answer 1

This may be of interest: http://bryanmills.net/archives/2003/11/microsoft-access-database-using-linux-and-php/

via http://stackoverflow.com/questions/2278970/database-connection-in-php-with-ms-access-on-linux-hosting

Answer 2

Take a look at this question: http://stackoverflow.com/questions/2278970/database-connection-in-php-with-ms-access-on-linux-hosting/

Most people (including me :) ) are recommending migrating the Access database to MySQL (or Postgres), and running that as the live database on the website. If there are people/processes in your office that rely on Access, you can use Access as a frontend by connecting it to the live MySQL database over ODBC.