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

[sloth456]

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.

[MatthewJ]

Getting them out of access is the best option

 

 

[Elridan]

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/