PHP MySQL database from MS Access

Question

I'm developing a php website that is only accessible from a company network. I've been using MySQL to develop my databases, but I need pertinent information that is located in a MS Access database (also located on the network).

The problem is that this MS Access database updates itself every 6 hours - so I will need to:

(1) Make a connection from my php site to the MS Access database located on the network.

(2) Have it periodically update itself.

I have absolutely no clue where to start. Any advice would be greatly appreciated.

Since the "MS Access database updates itself every 6 hours", adapt the Access db to update MySQL via ODBC links afterward. It's not clear why you should need PHP to mediate the data transfer from Access to MySQL. — HansUp
– HansUp, Commented Jan 14, 2014 at 23:25

Scott Savage · Accepted Answer · 2014-01-14 23:20:18Z

4

To have it periodically update itself, you may need to have a service do this. A webpage (running php) will only run when a user goes to that webpage.

answered Jan 14, 2014 at 23:20

Scott Savage

3731 gold badge4 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Scott Savage Over a year ago

As for connecting to Access look here: w3schools.com/php/php_db_odbc.asp

Collectives™ on Stack Overflow

PHP MySQL database from MS Access

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related