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. Quote 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 Quote 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/ Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.