Linking into a Microsoft Access database

Jon12345

I have a Microsoft Access database on my PC which I would like to be made accessable for a web front end. The web front end would be on mysite.com while the Microsoft Access database would reside on my PC.

My intention is to use php on the webpage.

But how would I do the link? Is it something I setup on my Win XP PC?

Thanks,

Jon

rsmith

Why can't you put the db onto the website mysite.com and then just use the php & odbc to connect to it? Here's a link on how-to:

http://www.w3schools.com/php/php_db_odbc.asp

Jon12345

There are many reasons, just take it from me that we can't.

rsmith

Then you'll probably need to have a webserver running that can server the database on your local machine. I would recommend Xampp as it comes bundled with PHP, Apache and some other good stuff. Or there's always shudder IIS. And then follow the how-to on that site to see if it applies to you.

Valdhor

I think rsmith had it right. Leave the MS Access DB on your PC (I assume it is on the local network protected by a firewall) and run the PHP server on the public network (Outside the firewall). Configure the firewall so that the only device that can access anything on the private network is the web server.

On the local PC side you will need to set up ODBC. See http://www.w3schools.com/php/php_db_odbc.asp

On the PHP server you will need to setup a connection and logic for CRUD (Create, Retrieve, Update, Delete). There are a number of sites around to show you this but here are a few:

http://www.phpfreaks.com/tutorials/61/0.php

http://www.web-max.ca/PHP/odbc_1.php

Not to mention the definitive PHP Site:

http://us3.php.net/manual/en/ref.uodbc.php

rsmith

You'll also need to check and see if your ISP blocks incoming Port 80. 9/10 will block this for residential people because they don't want users using their bandwidth to hosts sites. If that's the case you'll need to use an alternate port, such as 81 (i do), to host my stuff and setup your application to access your private network on port 81.