Newbie question: Accessing MS Access databases?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
masken
Forum Newbie
Posts: 2
Joined: Tue Jun 25, 2002 10:17 am
Location: Gothenburg, Sweden
Contact:

Newbie question: Accessing MS Access databases?

Post 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?
Matt Wade
Forum Newbie
Posts: 12
Joined: Sat May 04, 2002 7:47 pm

Post 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....
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
masken
Forum Newbie
Posts: 2
Joined: Tue Jun 25, 2002 10:17 am
Location: Gothenburg, Sweden
Contact:

Post by masken »

Ok :) So I don't need MS's own ODBC drivers to connect then I guess, sounds great :)

Thanks for the help :)
Post Reply