How To: Access .mdb database with PHP?

[bubu]

I would like to know how can I use Access .mdb databases with PHP.
I would apreciate very much a small snipet.
Also, what are the dependencies for such database to work in php? (dlls, mdac, etc...)

Thanks your for your atention!

[Amn]

Man thats a no-brainer in Windows if you have access to the server. If not you have to ask your host provider or use some sort of interface to create a DSN (this is what you use in odbc_connect PHP function to connect to a data source) which will be mapped to an Access Database. I will not explain you how to do it, because all ISPs have their own way of doing this.

If you host PHP on a Windows machine and you can access the Administrato desktop:

1. Go to Control Panel->Administrative Tools->Data Sources (ODBC). You can make a new data source name there.

2. Use this name in odbc_connect.

Dont forget to create an Access database with your tables !