compatible PHP db

[Walyer]

Is it possible to use MS Access as a db with PHP?

If so, how?

If not, is there a way to convert (for free without buying a program) MS Access file to MySQL?

Thanks for your efforts

[alpha_foobar]

dunno about a free (tool) to do this, but if you can export your database as sql.. (not sure if you can do this in access, i know you can in that other cheap ms database [sql server]).. but if you can do this, then just export the data into some csv format and import that into cool db of choice!

[sarahk]

There is some information in the PHP manual for odbc_connect - look at the user comments.

sarah

[big_k105]

from the searching i have done it looks like you can convert from access to mysql i have found a migration thing on the mysql website i dont know if its free but if you do a search on google for a access to mysql converter you will find alot of options here are a few i found :)
http://www.fonlow.com/zijianhuang/dbconverter/
the one from the mysql db here : http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-sourcedb-access.html

and if you really want to use access which most people will say dont. there are ways just do a quick google search for php + ms access and you will find a few options :) good luck