sloth456 Posted December 14, 2010 Share Posted December 14, 2010 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. Link to comment https://forums.phpfreaks.com/topic/221667-how-can-my-php-website-use-a-ms-access-db-kept-on-a-seperate-computer-in-my-shop/ Share on other sites More sharing options...
MatthewJ Posted December 14, 2010 Share Posted December 14, 2010 Getting them out of access is the best option Link to comment https://forums.phpfreaks.com/topic/221667-how-can-my-php-website-use-a-ms-access-db-kept-on-a-seperate-computer-in-my-shop/#findComment-1147331 Share on other sites More sharing options...
Elridan Posted December 14, 2010 Share Posted December 14, 2010 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/ Link to comment https://forums.phpfreaks.com/topic/221667-how-can-my-php-website-use-a-ms-access-db-kept-on-a-seperate-computer-in-my-shop/#findComment-1147341 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.