PHP connect MS Access

[neltan]

Hi PHP Experts,
I have to connect a MS Access file (store in NT server) from a php (install in another linux server).
I found that I can access through
1. iODBC
2. unixODBC

But it seems iODBC is not totally free and unixODBC is not so 'standardize'?

Please give comment on how to do that. Thank you.

 

[jimoblak]

This may not help but it is what I ended up doing in a similar situation...

I dumped the MS Access tables into a MySQL database. PHP connects easily to MySQL. Then I went back to Access and set the Access tables to pull from the MySQL data via 'machine source' ODBC. You can get MyODBC from mysql.com to allow MS Access to access the MySQL data.

 

[neltan]

Thank you jimoblak.

My Access file is stored in NT server. And we won't let people access the file directly. But php instead.

I not only retrieve data from Access, but also add, edit, delete from another linux server.

2 different server:
PHP (Linux) --> Access (NT)

Would it be any DSN problem here?
Can I use direct connection to mdb file instead of DSN?