Page 1 of 1

Newbie question: Accessing MS Access databases?

Posted: Tue Jun 25, 2002 10:17 am
by masken
Hi all

I'm a total newbie to the world of PHP, so please bare with me ;)

I'm considering how I should publish an MS Access database that I have. The thing is i'm updating this DB through MS Access too, so i'd rather keep this original format.

But I also want to build a couple of HTML pages with content from the DB, and i'm considering how I should do this.

The "simplest" solution would be to grab the MDAC 2.7 and do it in ASP I guess :?:

But is it possible to combine/access an MS Access database through PHP?

Posted: Tue Jun 25, 2002 7:39 pm
by Matt Wade
You should take a look at the ODBC functions in PHP. With them, you can connect to an Access database no problem....

Posted: Wed Jun 26, 2002 2:36 am
by twigletmac
Yup, PHP can connect to lots of different types of databases and the way that you would use MS Access generally is via ODBC (somewhere in this forum there's also some info on using COM objects but you'll need to search for that). In case you were wondering where to start on finding out about the ODBC functions in PHP try here:
http://www.php.net/manual/en/function.odbc-connect.php

Mac

Posted: Thu Jun 27, 2002 9:57 am
by masken
Ok :) So I don't need MS's own ODBC drivers to connect then I guess, sounds great :)

Thanks for the help :)