Jump to content

How can my PHP website use a MS Access DB kept on a seperate computer in my shop


sloth456

Recommended Posts

Hi,

 

I have a challenging dilema.  A client keeps track of his stock using a microsoft access database in store.  His ecommerce website which is hosted elsewhere uses php and mysql.

 

Is it possible to to integrate the 2 so that when someone buys a product from the website, the store MS access database is updated to reflect this and vice versa?

 

If so how would I go about it?

 

Thanks in advance.

 

P.S: I'm extremely tempted to suggest that he should stop using his ms access db and instead reccommend that I set him up a suitable backend on his website for keeping stock control, then he just login to that in the store.

I would look into getting an ODBC driver for Access and connecting to it that way.  Here is the manual for ODBC Functions and a possible driver; I've never done it myself.

 

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

 

http://www.easysoft.com/products/data_access/odbc-access-driver/

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.