How do I connect a MS Access database to a website using PHP? [Archive]

tevans

February 10th, 2003, 09:07 AM

Please help me!!:( I have built a database on members of a club, but would like to be able to connect this to a simple website (using PHP) which allows the user to submit their details via a form and log on to alter their details. What coding do I use?
Also, what part does the web server play?? :rolleyes:
Thank you..

Tom.

antares686

February 10th, 2003, 02:50 PM

Not sure how much the web server plays as most connections are based in OLE,ADO, or ODBC connectivity. So as far as I know as long as you are running on a Windows based machine you can do it, but not others. However since PHP is not in my background yet I had to look around. Here is an example I found that seems to be well taken

Microsoft Access Database Connectivity (Windows) (http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=303&lngWId=8)

Just basic starter stuff. The rest should be generic DB stuff.