Linux, PHP and Microsoft Access

estratosphere · 3 Oct 2006 at 23:30

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 · 4 Oct 2006 at 08:56

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 · 4 Oct 2006 at 09:00

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 · 4 Oct 2006 at 09:17

Use the odbc connection functions manual for ref.

http://php.net/odbc

Code:

<?php

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

?>