php, access and apache

lovely

Hello
I have started a database in access, originally was going to use ASP and download IIS however cannot find a windows 2K version of IIS to support ASP.
I have previously downloaded Apache as I have used this inthe past.
i want to know if PHP and apache is compatable with Microsoft Access. Will it all work together and where can I find resources such as tutorials help and info about these working together? I would like to be proficient in extracting, saving updating information and wriitng scripts to the databse.

Can anyone help?
Thanks😕

jpmoriarty

ASP is a micro$oft invention, so IIS for win 2k server supports asp by default, and win 2k client includes a version of IIS that can support up to 5 concurrent users. It's possible to get it to run php too, but certainly by default it will run active server pages.

as for php and access, yes it's possible. You need ODBC drivers (which are installed as part of access), and if you serach the manual for ODBC (or just microsoft access even) you'll turn up a lot of useful stuff.

lovely

Cheers. will have a go. 🙂

Faron

Why even bother with Access. In the long run a better solution would be MySQL and there is alot of docs to help.

lovely

I used Access because Its a simple Database... (well ish) so i thought that as I started in Access (origianlly with the intention to use ASP with it. I thought I would stick with it. Right now .. i am having problems running my web page with Apache. It just seems to display a blank page instead of my homepage which I have renamed to index.html.en. So that is very confusing.. hmm

Faron

2 questions come to mind, first does your web page contain PHP?

If so then you may need to modify your httpd file in apache to add php. See install file in your php directory for the os you are using.

If you are not using PHP yet, then you still may have to modify the httpd file to point to the correct path to the "DocumentRoot" where your html file is. By default it is in the htdocs directory.

lovely

hiya,

Well the computers are networked and i was trying to get php to work on the computer 2. however, for some reason i could not get the homepage to run on computer 2 it was only display a blank page (yes i did sort out the install correctly). For some reason one computer would not work, and thn i tried the other computer networked computer and it worked!!! everything was the same! it would display my homepage in the localhost address on the other network computer but not the original one.. Weird...
now i'm working on another computer instead.
cheers