Linux, PHP and Microsoft Access

[estratosphere]

I have a client that wishes to display the information from an existing Microsoft Access database on their webpage.

Now I know that you have to use the ODBC connection to do this, but I am not sure how to get this working on linux.

Any help would be greatly appreciated.

 

[fluiduk]

Dont do it!!!

Convert the access database to MySQl. There a loads of tools out there to do it, took me about 10 minutes to do this when I needed to for a client.

Access is a slow old dog lol

Aaron

 

[chesterstu]

It depends on how many users there are, if you are going to have more than 5 concurrent users then you are better off converting to MySQL. If not google PHP MS Access there are millions of tutorials out there on how to connect.

 

[Dj_Jestar]

Use the odbc connection functions manual for ref.

http://php.net/odbc

<?php

$conn = odbc_connect('/path/to/db.file', 'user', 'password');

?>